Wayne,
take a look at this article.
It was in FoxPro Advisor last year but you can get it here for free.
I got lost of ideas out of it.

http://www.levelextreme.com/Magazine/August2001/Page25.asp


>Hi Steve:
>
>Thanks for the reply _tally would work nicely. Certainly better than using reccount(). Do you know how to retrieve values of variables from the server or run a function native only to the SQL server and get the results. You can do it in ASP & PHP how would you do it VFP?