DB2 10 - DB2 SQL - STRIP - sql db2 strip

Category

Db2 TRIM Function sql db2 strip


The STRIP function removes blanks or another specified character from the end, the beginning, or both ends of a string expression.

The STRIP function removes blanks or another specified character from the end, the beginning, or both ends of a string expression.​ The expression must return a value that is a built-in CHAR, VARCHAR, BINARY, VARBINARY, GRAPHIC, VARGRAPHIC, numeric, or datetime data type.

SELECT TRIM(L '0' FROM:BALANCE) FROM vvv-groesbeek.infoMY1. Results in ' '. Parent topic: Scalar functions. Related reference: STRIP.