if (@save_as is null) begin declare @count int set @count = 0 set @save_as = "Default" while ( exists("select id from _order_ship where save_as = '"+ @save_as +"'") ) begin set @count = @count + 1 set @save_as = @save_as +''+ convert(varchar(5), @count) end end if