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
Other forms:
trim(leading from …),trim(trailing from …),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.
