Using # in an Access Query

Ran into a little gotcha in Access today.

While trying to do a like query on a couple of text fields I found that searching for "C#" was not bringing back as many results as expected.
Turns out that # is a reserved word in a like query so to use  "like '*c#*' " your query need to be written as  "like '*c[#]*' "

FMS have some good info here

No Comments