Major Differences

The major differences between Microsoft Jet Database Engine SQL and ANSI SQL are listed below:

• Microsoft Jet SQL and ANSI SQL each have different reserved words and data types. For more information, see Microsoft Jet Database Engine SQL Reserved Words and Equivalent ANSI SQL Data Types.
  
  
• Different rules apply to the Between...And construct, which has the following syntax:

  expr1 [NOT] Between value1 And value2

  In Microsoft Jet SQL, value1 can be greater than value2; in ANSI SQL, value1 must be equal to or less than value2.

• Microsoft Jet SQL is generally less restrictive. For example, it permits grouping and ordering on expressions.
  
  
• Microsoft Jet SQL supports more powerful expressions.
  
  
• Different wildcard characters are used with the Like operator as shown in the table below.

  Matching character	Microsoft Jet SQL	ANSI SQL
  Any single character	?	_ (underscore)
  Zero or more characters	*	%