这个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 '

刚才反过来了

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