Sql Server 2005 去掉字段中的空格
时间:2022-03-10 17:40
SELECT replace(ltrim(rtrim(Realname)),‘ ‘,‘‘) AS Realname FROM UserInfo WHERE replace(ltrim(rtrim(Realname)),‘ ‘,‘‘) =‘张飞‘
Sql Server 2005 去掉字段中的空格,布布扣,bubuko.com
时间:2022-03-10 17:40
SELECT replace(ltrim(rtrim(Realname)),‘ ‘,‘‘) AS Realname FROM UserInfo WHERE replace(ltrim(rtrim(Realname)),‘ ‘,‘‘) =‘张飞‘
Sql Server 2005 去掉字段中的空格,布布扣,bubuko.com