TRIM( [ trimOperands ] trimSource)
trimOperands ::= { trimType [ trimCharacter ] FROM | trimCharacter FROM } trimType ::= { LEADING | TRAILING | BOTH } trimCharacter ::= æ–‡å—å¼? trimSource ::= æ–‡å—å¼?
trimSourceã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?ŒCHARã?‚ã‚‹ã?„ã?¯VARCHARã?ªã‚‰ã€?TRIM関数ã?®è¿”り値ã?®åž‹ã?¯VARCHARã?§ã?™ã€‚ã??れ以外ã?®å ´å?ˆã€?TRIM関数ã?®è¿”り値ã?®åž‹ã?¯CLOBã?§ã?™ã€‚
-- 'derby'を返���。(空白��り��ん。)
VALUES TRIM(' derby ')
-- 'derby'を返���。 (空白��り��ん。)
VALUES TRIM(BOTH ' ' FROM ' derby ')
-- 'derby 'を返���。 (末尾�空白��り��。)
VALUES TRIM(LEADING ' ' FROM ' derby ')
-- ' derby'ã‚’è¿”ã?—ã?¾ã?™ã€‚ (å…ˆé ã?«äºŒã?¤ç©ºç™½ã?Œã?‚りã?¾ã?™ã€‚)
VALUES TRIM(TRAILING ' ' FROM ' derby ')
-- NULLを返���。
VALUES TRIM(cast (null as char(1)) FROM ' derby ')
-- NULLを返���。
VALUES TRIM(' ' FROM cast(null as varchar(30)))
-- ' derb'ã‚’è¿”ã?—ã?¾ã?™ã€‚(å…ˆé ã?«ç©ºç™½ã?Œã?‚りã?‚ï½?ã?™ã€‚)
VALUES TRIM('y' FROM ' derby')
-- trimCharacterã?«ã?¯ä¸€æ–‡å—ã?—ã?‹æŒ‡å®šã?§ã??ã?ªã?„ã?®ã?§ã‚¨ãƒ©ãƒ¼ã?¨ã?ªã‚Šã?¾ã?™ã€‚
VALUES TRIM('by' FROM ' derby')