STRIP

The STRIP function removes blanks or another specified character from the end, the beginning, or both ends of a string expression.

Read syntax diagramSkip visual syntax diagram
>>-STRIP--(--expression--+-----------------------------------------+--)-><
                         '-+-,--BOTH-----+--+--------------------+-'      
                           +-,--B--------+  '-,--strip-character-'        
                           +-,--LEADING--+                                
                           +-,--L--------+                                
                           +-,--TRAILING-+                                
                           '-,--T--------'                                

The STRIP function is identical to the TRIM scalar function. For more information, see TRIM.