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