Access Fuzzy Query considerations

The problem that the Access fuzzy query appears, need attention in development!
In SQL Server, a fuzzy query is typically such a select * from articletable where authorname like '%jacky% '
But in Access using this statement to execute the time unexpectedly found no results, how is it possible?

Later, we looked up the following information and found the following problems:
To make a fuzzy lookup, you must use wildcards, and the access library has a different wildcard character than SQL Server.


The wildcard characters for the Access library are:
* matches any number of characters.
? Match with any single letter of character
The wildcard characters in SQL Server are:
% matches any number of characters
-Matches a single character

The correct wording should be:

Written in C # should be written as Select * from Table where Name like '%jacky% '

Select * from Table Where Name like ' _jacky_ '

The test statement in Access should be written as: Select * from Table Where Name like ' *jacky* '

Select * from Table Where Name is like '? Jacky? '

Access Fuzzy query considerations