1 of 1

trim

This section contains reference documentation for the trim function.

trim spaces from both side of the string

Signature

TRIM(col)

SELECT ' Pinot with spaces  ' AS notTrimmed,
       trim(' Pinot with spaces ') AS trimmed
FROM ignoreMe

notTrimmed

trimmed

This section contains reference documentation for the trim function.

trim spaces from both side of the string

TRIM(col)

SELECT ' Pinot with spaces  ' AS notTrimmed,
       trim(' Pinot with spaces ') AS trimmed
FROM ignoreMe

notTrimmed

trimmed

" Pinot with spaces "

"Pinot with spaces"