a Find does not find all records in a Name field which has embedded apostrophes
Operating system version
Mac OS X, verions 10.6.8
Description of the issue
Can't seem to find a way to locate all records with an apostrophe in the name. Have tried just the apostrophe and combinations of "'", @', @"'", @*', @*"'". Substitute also does not seem to work.
Steps to reproduce the problem
To first find the records with an apostrophe in the name and then remove the apostrophe.
Names are not found and apostrophe is not removed.
Exact text of any error message(s) that appear
No error message appears. Desired result is just not achived.
Have had to do it manually.