For VFP6 you need to put your codes into a table.

>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