>Hi,
>
>I want to select 5 (or some other number) random records that match WHERE clause of the SQL Select. Is it possible?
>
>TIA.
/// More random :-)
SELECT TOP 5 *
FROM YourTable
WHERE SomeCondition
ORDER BY NEWID()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.