>Hi,
>
>I want to select 5 (or some other number) random records that match WHERE clause of the SQL Select. Is it possible?
>
>TIA.
RAND(-1)
lnMax = 5
SELECT TOP CEILING(RAND()*lnMax) * ;
FROM (HOME(2) + "Northwind\Orders") ;
WHERE EmployeeId = 1 ;
ORDER BY OrderId
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________