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