Major Differences

• 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.

• Different wildcard characters are used with the Like operator.

• Microsoft Jet SQL is generally less restrictive. For example, it permits grouping and ordering on expressions.
  
  
• Microsoft Jet SQL supports more powerful expressions.