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
" Pinot with spaces "
"Pinot with spaces"