The SQL function trim(<char> from …)
removes the specified character from both ends of the string. It can be combined with leading
and trailing
.
SELECT TRIM('0' FROM '00010.9900')
FROM …
The result of the example is the text '10.99'
with the zeroes removed from both ends.
Related
Options:
trim( [ [leading|trailing] [<char>] FROM ] …)
Only at on end:
trim(leading from …)
,trim(trailing from …)
From both ends (default):
trim(…)
Normative References
The trim()
function, including the ability to specify the character to be removed, is defined in ISO/IEC 9075:2016-2 as mandatory feature E021-09.