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