Like date type query distinguishes between access and SQL Server _ database other

The most recent problems with Access databases are summarized:

The use of like in Access

Like wildcard usage in Access is this:

“?” Represents any single character; "*" means 0 or more characters; "#" means any number

So it should be:

SELECT * from DatabaseName where fieldname like ' *xx* '

But in SQL SERVER, 0 or more characters are represented in%

Ii. How to query the date range data for a DateTime type field in Access

If the field is a time/date type, you are performing something like this
SELECT * FROM [card] where [datetime] <= ' 2006-09-20 ' and [datetime]>= ' 2006-09-01 '
An error occurs in Access, and you should precede the date field with "#" that is:
SELECT * FROM [card] where [datetime] <= #2006 -09-20# and [datetime]>= #2006 -09-01#