sql sever trim 去掉两边特殊字符

-- 去除字符串两端的空格

SELECT TRIM(' Hello World! ') AS TrimmedString;

 

 

-- 去除字符串两端的特定字符

SELECT TRIM('a' FROM 'aaHello World!aa') AS TrimmedString;