If values of two columns of different lengths are to be concatenated and the blanks between them are to be reduced, the function TRIM can be used.
In the following example, account values greater than zero are multiplied by 1.5 in order to convert them into DM amounts.
SELECT name, TRIM (CHR (account * 1.5)) & ' DM' account
FROM account
WHERE account > 0.00
RTRIM can be used to truncate one or more characters specified as second argument from the right of a column value.
The function LTRIM truncates characters from the left of a value.