------空格的ascii值为9
1.去除左边空格 LTRIM()
2.去除右边空格 RTRIM()
3. 去除回车符 REPLACE(@str, CHAR(13) , '')
4.去除换行符 REPLACE(str, CHAR(10), '')
5.去除回车换行符 REPLACE(str, CHAR(13) + CHAR(10), '')
6.替换空格 REPLACE(@str,' ','')
------空格的ascii值为9
1.去除左边空格 LTRIM()
2.去除右边空格 RTRIM()
3. 去除回车符 REPLACE(@str, CHAR(13) , '')
4.去除换行符 REPLACE(str, CHAR(10), '')
5.去除回车换行符 REPLACE(str, CHAR(13) + CHAR(10), '')
6.替换空格 REPLACE(@str,' ','')