The SQL function trim(…) removes space characters from both ends of a string.
SELECT TRIM(' traveling spaces ')
FROM …The result of the example is the text 'traveling space' with the leading and trailing spaces removed.
Related
Options:
trim( [ [leading|trailing] [<char>] FROM ] …)Only one end:
trim(leading from …),trim(trailing from …)Another character:
trim(<char> from …)From both ends (default):
trim(both from …)
Normative References
The trim() function is defined in ISO/IEC 9075:2016-2 as mandatory feature E021-09, “TRIM function”.
