STRIP
The STRIP function removes blanks or another specified character from the end, the beginning, or both ends of a string expression.
>>-STRIP(string-expression-+---------------------------------------+-)->< | .-BOTH-----. | '-,--+----------+--+------------------+-' +-B--------+ '-,--trim-constant-' +-LEADING--+ +-L--------+ +-TRAILING-+ '-T--------'
The schema is SYSIBM.
The STRIP function is similar to the TRIM scalar function.