STRIP scalar function

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.

Notes

Valid content for EBCDIC mixed string input:
If string-expression is an EBCDIC mixed string, the string must contain valid EBCDIC mixed data.