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.
