SQL · System and metadata

quote()

Returns a SQL literal for a value, with NULL rendered as NULL. SQLite.

sqlRunnable example sql course

Syntax

quote(value)

Example

Open in the lab

SELECT quote('it''s') AS quoted;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.