>Hi,
>
>I want to select 5 (or some other number) random records that match WHERE clause of the SQL Select. Is it possible?
>

Sure, do something like this:

RAND(-1) && to seed it
SELECT TOP 5 <the fields you want>, RAND() as nRand ;
  FROM <your table> ;
  WHERE <your conditions> ;
  ORDER BY nRand

Tamar