Hi Jeremy,
Lets have a look at the SQL <g> Maybe there is another solution...
>I tried your solution and this is what I found,
>
>Foxpro still has to substitute the macro stuff and when it does, it gets a command that is too long. I don't think it matters how many macros you use, FoxPro still has to evaluate the information, and when it does, You will get the same error message.
>
>Unless I am missing something.
>
>Jeremy Weidig