Entry Format for Character Data

Literal char, varchar, and text values—or their equivalents—must be enclosed in single quotation marks.

You can embed single quotation marks in char and varchar literals in two ways. Use two consecutive quotation marks to represent a single embedded quotation mark, as in this example:

'''You can have cake if you bake it,'' Ed claims.'

The first and last quotation marks delimit the character string. The two internal pairs of quotation marks are interpreted as embedded single quotation marks.

Replication Server generates single quotation marks when it substitutes a character value for a variable in a function-string template.