<< I imagine the syntax is not supported on an ODBC table like the above "LAST" clause, but it just does not return an error. >>
That's entirely possible but, just to be sure, check the ODBC driver version you're using. COUNT = INSERT is a (relatively) recent addition to R:Base, if you're using an older ODBC driver it might predate the COUNT = INSERT syntax. -- Larry

