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

Start of changeValid content for EBCDIC mixed string input:End of change
Start of changeIf string-expression is an EBCDIC mixed string, the string must contain valid EBCDIC mixed data.End of change