这个SQL对吗 convert解决方法

这个SQL对吗 convert
update   Userinfo   set   huiyuan= '000000 '   where     Convert(bigint,accounts) <=88800011   and   Convert(bigint,accounts> =88800010
accounts   是char   型



[解决办法]
--try

update Userinfo set huiyuan= '000000 ' where
Convert(bigint,rtrim(ltrim(accounts))) between 88800010 and 88800011

[解决办法]
accounts中必须是纯数字的字符串.
[解决办法]
update Userinfo set huiyuan= '000000 ' where isnull(accounts, ' ')between '88800010 ' and '88800011 '

刚才反过来了

[解决办法]
字段上最好加上约束。