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.

Start of change

The STRIP function is similar to the TRIM scalar function.

End of change