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 |