TRIM 함수

설명

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'