Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Quoted String
Using Quotation Marks in Strings

Using Quotation Marks in Strings

The single quotation mark ( ' ) has no special significance in string literals delimited by double quotation marks. Conversely, double quotation mark ( " ) has no special significance in strings delimited by single quotation marks. For example, these strings are valid:

"Nancy's puppy jumped the fence"
'Billy told his kitten, "No!" '

A string delimited by double quotation marks can include a double quotation mark character by preceding it with another double quotation mark, as the following string shows:

"Enter ""y"" to select this row"

When the DELIMIDENT environment variable is set, double quotation marks can only delimit SQL identifiers, not strings. For more information on delimited identifiers, see Delimited Identifiers.