declare @i int ,@j int
set @i=1
select @j=max(rowid) from #b
while @i<=@j
begin
select rowid from #b where rowid=@i
declare @g int
set @g=0
while @g<=9
begin
print (@g)
update #b set c_company_name =REPLACE(c_company_name,@g,'')
where rowid=@i
set @g=@g+1
end
set @g=0
set @i=@i+1
end