STRIP

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

The STRIP function removes blanks or another specified character from the end and/or beginning of a string expression.

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