The VFP versions prior to VFP9 used the INLIST() function for IN operations. IIRC, the INLIST() function supports no more than 25 parameters.

>I try your code with VFP9 and all is well. No error.
>I don't know where is the problem.
>
>>Hi All,
>> I am using the simple select statement and getting the following error:
>>
>>Error is SQL expression is to complex
>>
>>my select is
>>
>>SELECT Regno from Test group by Regno order by Regno ;
>>Where Regno not in(12,41,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,7012,59,60,61,62,63,64,65,66,67)
>>
>>Any Ideas?
>>
>>Thanks