select @len=len(@re)
select @i = CHARINDEX ( '0', @str, 0 )
select @str= substring( @str, 0, @i )+'1'+substring( @str, @i+1,@len )
select @i = CHARINDEX ( '0', @str, 0 )
select @str= substring( @str, 0, @i )+'1'+substring( @str, @i+1,@len )
set @str = '11100000' --11110000
set @i = 1
set @mylen =len(@str)
while @mylen >0
begin
if substring(@str,@i,1)='1'
set @i =@i +1
set @mylen = @mylen -1end
print @i
print substring(@str,1,@i-1)+replace(substring(@str,@i,1),'0','1')+substring(@str,@i,@i)