Entering Character Data

Character strings must be enclosed in single or double quotes. If you use set quoted_identifier on, use single quotes for character strings; otherwise, the SAP ASE 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.