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