Dremio Cloud
Dremio Software
 
On this page

    Categories: String

    QUOTE

    Returns a result that can be used as a properly escaped data value in a SQL statement.

    Syntax

    QUOTE(expression string) → string

    • expression: The input string.

    Examples

    QUOTE example 
    SELECT QUOTE('Dremio')
-- 'Dremio'
    QUOTE example using escaping single quotes 
    SELECT QUOTE('Sonar''and''Arctic') 
AS Escaped_String

-- 'Sonar\'and\'Arctic'
    QUOTE example that quotes from a column in sample NYC taxi data 
    SELECT *, QUOTE(total_amount) 
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips" 
LIMIT 3

-- pickup_datetime, passenger_count, trip_distance_mi, fare_amount, tip_amount, total_amount, EXPR$6
-- 2013-05-27 19:15:00.000, 1, 1.26, 7.5, 0.0, 8.0, '8.0'
-- 2013-05-31 16:40:00.000, 1, 0.73, 5.0, 1.2, 7.7, '7.7'
-- 2013-05-27 19:03:00.000, 2, 9.23, 27.5, 5.0, 38.33, '38.33'

    Usage Notes

    The string is returned enclosed by single quotation marks and with each instance of backslash (\), single quote (‘), ASCII NUL, and Control+Z preceded by a backslash (\). If the argument is NULL, the return value is the word NULL without enclosing single quotation marks.