TRIM 함수는 문자열의 앞, 뒤 또는 앞뒤에 위치한 특정 문자들을 제거한다.
TRIM ( [ [ LEADING | TRAILING | BOTH ] [ trim_string ] FROM ] string )
trim_string :
• character string
• NULL
string :
• character string literal
• string valued column
• NULL
--trimming NULL returns NULL
SELECT TRIM (NULL);
======================
NULL
--trimming spaces on both leading and trailing parts
SELECT TRIM (' Olympic ');
======================
'Olympic'
--trimming specific strings on both leading and trailing parts
SELECT TRIM ('i' FROM 'iiiiiOlympiciiiii');
======================
'Olympic'
--trimming specific strings on the leading part
SELECT TRIM (LEADING 'i' FROM 'iiiiiOlympiciiiii');
======================
'Olympiciiiii'
--trimming specific strings on the trailing part
SELECT TRIM (TRAILING 'i' FROM 'iiiiiOlympiciiiii');
======================
'iiiiiOlympic'