I am having to prepare test data to send to a 3rd party however I don't wish to send the customers real name nor do I wish to send their real date of birth.

I could solve the D.O.B issue by just randomly increasing the DOB by several years. However the name is different, is there anyway I can have a list of say 10 customer names and just choose a different Firstname and Surname each time.

I wish to mix and match the names however so it essentially randomly picks 1 firstname and then randomly picks a lastname and puts them together on the same line.

```
SELECT TOP 1 opde.first_name 
FROM Table AS opde
ORDER BY NEWID()

```

This will return a random first name each time, but if I put the surname column in it will also return the matching surname, I don't want that I want a random surname from the list.

I tried doing this via a `UNION` but you can't do an `ORDER BY NEWID()` in the `UNION`.

Cheers.