반응형
/*******************************************************************************************************************
-- Title : [SQL2017] 지정된 문자열을 활용한 TRIM() 함수
-- Reference : docs.microsoft.com
-- Key word : trim trim()
*******************************************************************************************************************/
■ Scripts
-- 기본 TIRM
SELECT rtrim(ltrim( ' test ')) AS Result;
SELECT TRIM( ' test ') AS Result;
-- 지정된 문자열에서 TRIM
SELECT TRIM( '.,! ' FROM '!! # test .') AS Result;
반응형