The error IS in the sql statement. This is stated right in the error message: [Microsoft][ODBC SQL Server Driver]... This tells you that the SQL Server driver is telling you that the SQL statement is incorrect. Dave