The single quote ( ' ) has no special significance in string literals delimited by double quotes. Conversely, double quote ( " ) has no special significance in strings delimited by single quotes. For example, these strings are valid:
"Nancy's puppy jumped the fence" 'Billy told his kitten, "No!" '
A string delimited by double quotes can include a double quote character by preceding it with another double quote, as the following string shows:
"Enter ""y"" to select this row"
When the DELIMIDENT environment variable is set, double quotes can only delimit SQL identifiers, not strings. For more information on delimited identifiers, see Delimited Identifiers.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]