Sql Server 2005 去掉字段中的空格

SELECT  replace(ltrim(rtrim(Realname)),' ','') AS Realname
FROM  UserInfo
WHERE  replace(ltrim(rtrim(Realname)),' ','') ='张飞'