Trimming Trailing spaces in Teradata

In Teradata, you can trim the TRAILING spaces like below.

Syntax:
SELECT TRIM(TRAILING FROM 'string' or number)


Example:
SELECT TRIM(TRAILING FROM '   asdfas  ')||'a'


Output:
asdfasa