>Yes. I'd prefer to call stored procedure, i.e. SQLExec(c,"execute ...") which will do the abovementioned operations.
Neat thing about the MS SQL Server ODBC driver is that if the command contains anything that the driver cannot translate, it passes it to SQL Server as is. This provides a way to submit non-ODBC SQL commands within using the ODBC escape clause.
-Mike