XTRIM

ANSI DB2 SQL/DS XDB
      X

Trims trailing spaces from a character string. The format appears below:

XTRIM(x)

The parameter x is any expression that evaluates to a character string. For example:

SELECT XTRIM(lname)
FROM employee