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(' traveling spaces ')
FROM …The result of the example is the text 'traveling space' with the spaces removed from both ends.
Related
Other forms:
trim(leading from …),trim(trailing from …),trim(…),trim(<char> from …).Product specific forms:
rtrim()
Normative References
The trim() function, including the both from keywords, is defined in ISO/IEC 9075:2016-2 as mandatory feature E021-09.
