>Thanks Mark, did this sintax work on a idc file as you put it to me ?
>Did you check the page http://www.ucguate.com/texzibe/buscar.htm
>
>thanks for your help, I will let you know

I do not know what an IDC file is. I do see you are running this query against a a VFP table. So where are you generating the SQL code? In a VFP function? Then running the SQL in VFP code?

The example I gave you, if executed under VFP code, should work.

What are you using? Web-Connect? Your own?