trim

This section contains reference documentation for the trim function.

trim spaces from both side of the string

Signature

TRIM(col)

notTrimmed

trimmed

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

" Pinot with spaces "

"Pinot with spaces"