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.