Adds double quotation marks to a character value.
Category: | Character |
Returned data type: | NCHAR |
specifies any valid expression that evaluates to a character string.
Data type | NCHAR |
See | <sql-expression> |
FedSQL Expressions |
Statements
|
Results
|
---|---|
select quote('A"B'); |
"A""B" |
select quote('A''B'); |
"A'B" |
select quote('Paul''s Catering Service'); |
"Paul's Catering Service" |