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
Other forms:
trim(leading from …),trim(trailing from …),trim(both from …),trim(<char> from …).
Normative References
The trim() function is defined in ISO/IEC 9075:2016-2 as mandatory feature E021-09.
