Hi
The following is from MS Access help:
The two ANSI SQL query modes, ANSI-89 and ANSI-92, are not compatible
and use different wildcard characters. For example, if you run:
An ANSI-89 SQL query in a database set to ANSI-92 query mode, such as:
SELECT * FROM Customers WHERE Country Like 'U*'
It returns all customers from a country/region named "U*", not all
countries/regions beginning with the letter "U", because the asterisk
(*) is not a wildcard character in ANSI-92 SQL.
An ANSI-92 SQL query in a database set to ANSI-89 query mode, such as:
SELECT * FROM Customers WHERE Country Like 'U%'
It returns all customers from a country/region named "U%", not all
countries/regions beginning with the letter "U", because the percent
sign (%) is not a wildcard character in ANSI-89 SQL.
When you create a Microsoft Access database, you need to decide which
query mode you are going to use because if you create a later query
under a different ANSI SQL query mode than the current mode of your
Access database, your query could produce runtime errors or unexpected
results.
James