Removes blanks or another specified character from the end or beginning of a string expression.
The first argument is optional and indicates whether characters are removed from the end or beginning of the string. It can have a value of B, L, or T. The second argument is also optional, and is a single-character constant that indicates which character is to be removed. The third argument must be a string expression.
Example:
Assume column BALANCE has a value of '000345.50'.
TRIM( L '0' FROM BALANCE )
Results in: '345.50'