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.