Trimming Leading spaces in Teradata

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

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


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


Output:
asdfas a