The like of ACCESS

Learned SQL lessons in W3school, knowing the commands, functions, etc. used in the database.

The examples given in the course are mostly used in SQL Server and have recently begun to run under MS Access. There are certain differences, such as those encountered today: likeoperators .

Like is used to search for a specified pattern in a where sentence, such as what begins, ends, and what is in the middle ...

In the example given, use "%" in conjunction with the definition of wildcard characters (missing letters in the pattern).

Like what:

Persons table:

in Access, I create a persons-like table that uses the same statement but doesn't run out of the desired results. I searched the internet a bit, the problem is on the wildcard!

In Access, the wildcard character used is "*" instead of "%"

In other words, running in Access is a statement that should be:

SELECT * from Persons
WHERE city like ' n '

-----------------p.s. Content is 2013.11.26 local collation-----------------