Contents Index Identifiers Operators

ASA SQL Reference
  SQL Language Elements

Strings


Strings are of the following types:

An expression with a CHAR data type may be a built-in or user-defined function, or one of the many other kinds of expressions available.

For more information on expressions, see Expressions.

A literal string is any sequence of characters enclosed in apostrophes ('single quotes'). A SQL variable of character data type can hold a string. The following is a simple example of a literal string:

'This is a string.'
Special characters in strings 

You represent special character in strings by escape sequences, as follows:

See also 

For information about the handling of strings in dynamically constructed SQL statements, see EXECUTE IMMEDIATE statement [SP].

Standards and compatibility 

For compatibility with Adaptive Server Enterprise, you can set the QUOTED_IDENTIFIER database option to OFF. With this setting, you can also use double quotes to mark the beginning and end of strings. The option is set to ON by default.

For information about the QUOTED_IDENTIFIER option, see QUOTED_IDENTIFIER option [compatibility].


Contents Index Identifiers Operators