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( string-expression,BOTHBLEADINGLTRAILINGT,trim-constant)

The schema is SYSIBM.

The STRIP function is similar to the TRIM scalar function.