>Hi Naomi...
>
>I tried you code on direct VFP tables. It worked fine. But when I used the same code via ODBC, it failed and gave me a syntax error.
>
>Any Idea ?
>
>Raz

Can you put the exact query your tried again to look at? What is your back-end? Also are you using SPT? If yes, you would not be able to execute complex queries like this through ODBC. Perhaps you can create a stored procedure instead?