Introduction to LIKE usage in ACCESS

The usage of like wildcard in Access is as follows :? Represents any single character; * Represents zero or multiple characters; # represents any number, so it should be: select * fromdatabasenamewherefieldnamelike * XX * originally used in SQLSERVER %, the ** number is used in ACCESS. No wonder the data cannot be found! However, if

The usage of like wildcard 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 *' originally used % in SQL SERVER, and used the ** number in ACCESS. No wonder no data can be found! However, if

The wildcard usage of like in Access is as follows:

"?" Represents any single character;

"*" Indicates zero or multiple characters;

"#" Indicates any number

So it should be: select * from databasename where fieldname like '* XX *'

Originally, it was % used in SQL SERVER, and ** used in ACCESS. No wonder no data can be found!

However, if you want to use % again in TableAdapter of VS2005, you cannot use !!!