The LTRIM function removes all specified characters from the left-hand side of a string.
LTRIM( string [, trim_string])
string :
• character string
• string valued column
• NULL
trim_string :
• character string
• NULL
--trimming spaces on the left
SELECT LTRIM (' Olympic ');
ltrim(' Olympic ')
======================
'Olympic '
--If NULL is specified, it returns NULL
SELECT LTRIM ('iiiiiOlympiciiiii', NULL);
ltrim('iiiiiOlympiciiiii', null)
======================
NULL
-- trimming specific strings on the left
SELECT LTRIM ('iiiiiOlympiciiiii', 'i');
ltrim('iiiiiOlympiciiiii', 'i')
======================
'Olympiciiiii'