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:2016-2 as mandatory feature E021-09.