Roy,

The SET EXACT command has no effect on SQL commnads. You'll need SET ANSI.

TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 7
SET ANSI OFF; 
SELECT * FROM Products WHERE eng_name = "C"
ENDTEXT	
lnResult = SQLEXEC(lnConn , lcSql )

>
>I'm using ODBC to Connect to a VFP 8 table. I sent a SQL command string thru ODBC and get results. The problem is that sometimes I want the SQL command to be executed with SET EXACT equal to OFF. How do I tell VFP thru ODBC to set the status to off when running that command?
>