Tuesday, January 1, 2008

How To Query for Literal Special Characters in a Where Clause

Often in a query you'll want to compare the data in your tables to some text, either a constant or a variable in your VBA code. The query you'll ask Access to process for you will have your text surrounded by either single or double quotes. But what if your data might have quotes in it, such as the product description 12" Ruler, or the last name O'Holloran?

This Micsorsoft article discusses the problem and proposes tactics for dealing with it.

No comments: