How do we use a string literal which contains an embedded single-quote (‘) character?

The standard SQL specifies that single-quotes in strings can be escaped by putting two single in a row. In this scenario, it works with the Pascal programming language.