Title

Finding record with quotes in field

Post

Hi,

I tried to find an answer for the following issue but could not see anything :

I have to perform a find on a number of records which can contain quotation marks. For example a field called "size" has text stored in it as 4" ( to signify units of measurements ), or could be something like 4" x 4" . When i try to do a find of the exact match , no record shows up. Whereas anything without quotes comes up fine.

Be careful. There are two kinds of quote marks. "Straight" and "smart" quotes. Smart quotes come in left and right forms. Your search criteria needs to specify the same type of quote character as is used in your data.