trim

This section contains reference documentation for the trim function.

trim spaces from both side of the string

Signature

TRIM(col)

Usage Examples

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

" Pinot with spaces "

"Pinot with spaces"

Last updated