Hi Norman,
If you're building SQL to send via ODBC to Visual FoxPro tables, you can only use certain commands. The list is available on your PC under the directory you installed VFP (i.e. HOME())+ \Distrib.src\System\DRVVFP.hlp. There is another helpful file there: VFPODBC.txt which has a lot of things to watch out for.
Hope this helps.
Marty
>UPDATE:
>could make it with:
>Datasource: texzibe
>Template: BUSCAR.HTX
>SQLStatement:
>+select *,einicial+entradas-salidas as exis
>+ from prod where
>+nombre like '%M_nombre%%%' .and.
>+color like '%M_color%%%'
>
>but know the problem is how to put that in upper() so it matches in lower or upper case entries
>
>Thanks, really urgent
Marty Smith, CSQE