Hi Mahmood,

It maybe that you have too many variables in that in(value_set), try breaking it into two sets and see if that works.

HTH
Beth

>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