SQL Update help needed

[Moley]

This is one for the dbo's out there...

I have an MSSQL database with a table in it dbo.useraccounts that has a field 'name' that is current populated with real users names. I need to anonymise all these entries into 'DOMAIN\User1', 'DOMAIN\User2', etc

Does anyone know a bit of sql I can run to achieve this?

Many thanks!

 

[Moley]

Thankyou for your help guys - this statement did the trick:

update Anonymous.dbo.useraccounts
set name = 'DOMAIN\User' + cast(useraccounts.id as varchar(3))

Again - many thanks!