>Mark:
>In vfp I can do it ok . No problem.
>See, this table is a vfp table but queried from a webpage as the www search wizard of vfp, so the command there via the idc file is the one that does not work, if you check the www.ucguate.com/texzibe/buscar.htm you can see what i am trying to do
>
>Regards and thanks

I did check the URL and saw the [State=37000][Error=901][Microsoft][ODBC Visual FoxPro Driver]Function argument value, type, or count is invalid. error message.

Is there any way you can look at the entire SQL string to make sure you have spaces before and after the AND condition and everywhere else? Other than, that, I do not know why the first and third SQL work, and the combination of the 2 fails. Especially with such a simple SQL syntax.