>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?
Mark McCasland
Midlothian, TX USA