Select Random records from a Table

[ramone109]

I have a table that is made up of the following columns:
RecID (primary key)
Name
Address
City
State
Zip
Phone

As an example, I need to pull 5000 records from this table where the state is New York. However, I need to make sure that I don't get the exact same records everytime I run the same query. Any help would be greatly appreciated. Thanks in advance.

 

[nigelrivett]

select top 5000 *
from tbl
order by newid()


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[ramone109]

Perfect!!! Thanks Nigel, I really appreciate it.