LTRIM 함수는 문자열의 왼쪽(앞 부분)에 위치한 특정 문자를 제거한다.
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'