>>It's not the most "modern" of code, but I think it should work for you. (or at least get you started)
>
>will
>select distinct work?cause that only works for indexs an u said select distinct * from my table ann...not all are indexes but ill play around with your second code thou should get me started an yes im using vfp tables

Did you try my suggestion?