replace(replace(@str,char(13),''),char(10),'')
去掉全角空格replace(replace(string,' ',''),' ','')
RTRIM()只能去掉半角空格
去掉数据库中的回车符和全角空格
最新推荐文章于 2023-04-21 09:46:23 发布
replace(replace(@str,char(13),''),char(10),'')
去掉全角空格replace(replace(string,' ',''),' ','')
RTRIM()只能去掉半角空格