TRIM 함수

설명

TRIM 함수는 문자열의 앞과 뒤에 위치한 특정 문자들을 제거한다.

구문

TRIM ( [ [ LEADING | TRAILING | BOTH ]
  [ trim_character_set ] FROM ] trim_operand )trim_character_set :

trim_character_set
:
character string
NULL

trim_operand :
character string literal
string valued attribute
NULL

예제

SELECT TRIM ('i' FROM 'iiiiiOlympic')
FROM db_root;

SELECT TRIM (LEADING 'i' FROM 'iiiiiOlympiciiiii')
FROM db_root;