| 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. |