replace(replace(@str,char(13),''),char(10),'') 去掉全角空格replace(replace(string,' ',''),' ','') RTRIM()只能去掉半角空格