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" |