CODEWITHSUNDEEP
sqlms-access
ChickSentMeHighE
ChickSentMeHighE

Reputation: 1706

"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", 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!

Upvotes: 0

Views: 1722

Answers (1)

BIBD
BIBD

Reputation: 15414

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 "=".

Upvotes: 1

Related Questions