>Hi,
>
>I want to select 5 (or some other number) random records that match WHERE clause of the SQL Select. Is it possible?
>
>TIA.
Here is a quick test I've tried:
SELECT TOP 5 *, RAND() as Rnd FROM itemTreeLog ORDER BY Rnd
If it's not broken, fix it until it is.
My Blog 
