Dmitry,

Please provide more info. about what EQ1NAME thru EQ16NAME would contain.

>I am running into the "SQL too complex" error. I think because the SQL statement can't be longer than something (probably 254K).
>
>Here is a segment of the SQL I am trying to create:
>
>

>select iif(EQ1,EQ1NAME+";","") + iif(EQ2,EQ2NAME+";","") + ;
>iif(EQ3,EQ3NAME+";","") AS EQLIST FROM MYTABLE
>

>
>The problem is that I have 16 of the IIF() statements (that it, EQ1 to EQ16) in the SQL Select.
>
>Any suggestions on how to get around this limit of SQL or simplify my statement?
>
>Thank you.