QUOTE_LITERAL

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a string suitably quoted to be used as an SQL string literal.

1quote_literal(<string>)

• <string>: The string to quote.

Returns a text value with appropriate quoting for use as a string literal.

• Embedded single quotes and backslashes are properly doubled.
• Returns NULL on NULL input.

Quote a string with an apostrophe.

1SELECT quote_literal(E'O\'Reilly') AS result;

Returns '''O''''Reilly'''.

• String Types