What's New in Microsoft Jet 4.0

Microsoft® Jet version 4.x has many new features, including additional SQL reserved words, SQL data types, and ODBC scalar functions. There is now more information comparing SQL with ANSI SQL and more information about equivalent ANSI SQL data types. ANSI SQL wildcards, the percent sign (%) and the underscore character (_), are available with Jet 4.x and the Microsoft OLE DB Provider for Jet.

For detailed information about these new features, see:

SQL Reserved Words	Comparison of Microsoft Jet SQL and ANSI SQL
SQL Data Types	Equivalent ANSI SQL Data Types
ODBC Scalar Functions	Using Wildcard Characters in String Comparisons

Microsoft Jet 4.x has new data definition language statements, new data manipulation language statements, additional methods for customizing Microsoft Windows® Registry settings, and additional settings for initializing the database engine driver.

For detailed information about these new features, see:

What’s New with Data Definition Language	What’s New with Windows Registry Settings
What’s New with Data Manipulation Language