>>What's the length limit on a SELECT statement?
>>
>>Thanks
>
>See VFP system capacities:
>*--------------
>Maximum # of characters per command line 8,192
>*--------------
>
>If you are talking about the number of fields you can involve, then it is 255.

It may be less if you're talking WHERE clause complexity. See Help for SYS(3055).