"Special" characters in ms access regarding search

Does the . (period) have any special meaning in ms access when search?

For example, I have a table with 2 columns. (FETT Elements and FETT search)

One of the FETT elements is called "Essa T4" and FETT search is "EssaHT4",开发者_Go百科 I would like to make the "EssaHT4" as "Essa*.HT4" however my searching doesn't come up as expected.

Does the dot notation have a special meaning in ms access?

thanks!

No, the period is not a wild-card.

As indicated here, the only ones you have to worry about are: *, ?, [], !, -, #, %, ^, _, and -.

Typically you would use them as part of a "like" comparison rather than "=".