QUOTE_LITERAL

Reference Guide > TDV Support for SQL Functions > Character Functions > QUOTE_LITERAL

QUOTE_LITERAL

Returns the given string, suitably quoted, to be used as a string literal in a SQL statement string. Embedded single quotes and backslashes are doubled.

Syntax

QUOTE_LITERAL ( string )

Example

SELECT QUOTE_LITERAL('Joseph D''Artagnan');