Desktop Driver ODBC SQL vs. Microsoft Jet SQL

The ODBC SQL supported by the Desktop Database Drivers is very nearly the same as the SQL supported by Microsoft Jet, with only two major differences:

• ODBCTL32.DLL translates strings passed by an application in ODBC escape syntax, such as date literals, procedure calls, scalar functions, and outer join calls, into strings that are compatible with Microsoft Jet. The Microsoft Access driver supports only ANSI string constants (with single quotation marks).
  
  
• ODBCJT32.DLL translates pattern-matching characters from those that ODBC uses to those compatible with the Desktop Database Drivers and Microsoft Jet. The search character for a single character is an underscore ( _ ) in ODBC and a question mark (?) in Microsoft Jet; the search character for a sequence of zero or more characters is a percent sign (%) in ODBC and an asterisk (*) in Microsoft Jet. Microsoft Jet also translates wildcards embedded in dynamic parameter values in parameter queries.