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

notTrimmed	trimmed
" Pinot with spaces "	"Pinot with spaces"