you could order by a random number

Use theTable
AFields(laStru)
Create Cursor cuOutput From Array laStru

** to get possible values
Select Distinct zip, biztype ;
  from theTable ;
  into cursor cuZipBiztype

Scan
  lcZip=cuzipbiztype.zip
  lcBiztype=cuzipbiztype.biztype

  ** get 2 random records
  Select top 2 zip, biztype, other1, other2, Rand()*10 as Ordering ;
    from theTable ;
    where zip=lcZip and biztype=lcBizType ;
    order by Ordering ;
    into cursor cuRandom

  Select cuOutput
  Append From DBF("cuRandom")
EndScan

>Hi All,
>
>We have a table with columns for zip and biztype. I need to randomly select two records per zip, per biztype. Is there a simple SQL command to do this?
>
>As usual thanks in advance for any help.
>
>Aloha,
>
>James