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 diagramSTRIP(expression,BOTH,B,LEADING,L,TRAILING,T,strip-character)

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