SQL script to iterativity change some field values

Hello SQL expert, I want to obscurate some fields in the table of my MS-SQL database. Feilds such as name/emailid/ip_address, I want to replace with random ascii value. How to iterativity change name/emailid/ip_address with obscurated value? My table design looks like the following. username varchar(50) password varchar(50) emailid nvarchar(100) code varchar(50) ip_address char(20) joinedon datetime sex char(1) bday date coupon int I need script which can run in Server Managment Studio. Something close in internet what I could find is the following. But it dont have any sort of obscuration. Can you write script and test and deliver the code to me? [login to view URL] select top 1000 TableID into #ControlTable from [login to view URL] where StatusID = 7 declare @TableID int while exists (select * from #ControlTable) begin select top 1 @TableID = TableID from #ControlTable order by TableID asc -- Do something with your TableID delete #ControlTable where TableID = @TableID end drop table #ControlTable