The SQL function trim(trailing from …) removes space characters from the end (right side) of a string.
SELECT TRIM(' traveling spaces ')
FROM …The result of the example is the text ' traveling space' with the trailing spaces removed.
Related
Other forms:
trim(leading from …),trim(…),trim(both from …),trim(<char> from …).Product specific forms:
rtrim().
Normative References
The trim() function, including the trailing from keywords, is defined in ISO/IEC 9075:2016-2 as mandatory feature E021-09.
