Skip to content

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

Posted in Development