TRIM or STRIP

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'