Differences between like and date types in access and SQL Server

Summary of problems recently encountered when using access databases:

I. Usage of like in access

The wildcard usage of like in access is as follows:

"?" Represents any single character; "*" Represents zero or multiple characters; "#" represents any number

So it should be:

Select * From databasename where fieldname like '* XX *'

However, in SQL Server, % Represents zero or multiple characters.

2. How to query date range data of datetime fields in access

If the field is of the time or date type, if you execute select * from [card] Where [datetime] <= '2017-09-20 'and [datetime]> = '2017-09-01' like this, an error is returned in access., "#" should be added before the date field: Select * from [card] Where [datetime] <= #2006-09-20 # And [datetime] >=# 2006-09-01 #