Previous Topic Next topic Print topic


STRIP

ANSI DB2 SQL/DS XDB
  X X X

Use the STRIP function to remove blanks or another specified character from the end, beginning, or both ends of a string expression. The format appears below:

STRIP (expression [,BOTH [,strip-character]|,LEADING |,TRAILING])

where:

expression A string expression.
strip-character A single character constant that indicates the character that is to be removed.
Previous Topic Next topic Print topic