Character strings must be enclosed in single or double quotes. If you use set quoted_identifier on, use single quotes for character strings; otherwise, Adaptive Server treats them as identifiers.
Strings that include the double-quote character should be surrounded by single quotes. Strings that include the single-quote character should be surrounded by double quotes. For example:
'George said, "There must be a better way."' "Isn't there a better way?"
An alternative is to enter two quotation marks for each quotation mark you want to include in the string. For example:
"George said, ""There must be a better way."" 'Isn''t there a better way?'
To continue a character string onto the next line of your screen, enter a backslash (\) before going to the next line.
For more information about quoted identifiers, see the section “Delimited identifiers”of the Transact SQL User’s Guide.