>Thanks for the post. Unfortunately, it doesn't quite work. If I use it to retrieve TOP 3 and the first two are blank and the next two have values, I'll get one blank and the two with values. I would want the two blanks at the top and the next row with a value.
>
>Mike
Mike,
I guess that you have unique key field for each record in b_pods table (say cId).
Add it to Order By clause and you should get only 1 record
SELECT TOP 1 * FROM B_PODS INTO CURSOR csrRETURN ORDER BY DESCRIP, cId
--sb--