Question: I've got a new varchar(10) field in a database with 1000+ records. I'd like to update the table so I can have random data in the field. I'm looking for a SQL solution.

I know I can use a cursor, but that seems inelegant.

MS-SQL 2000,BTW

Answer: 
```
update MyTable Set RandomFld =  CONVERT(varchar(10), NEWID())

```
If this is a one time thing just to get data into the system I really see no issue with using a cursor as much as I hate cursors they do have their place.