Apostrophes in MS SQL attribute fields can cause problems even for MS SQL database users. If GeoMedia is used to create the attribute query so that the apostrophe has another single quote then it will work.
Here are some examples:
Name = 'St. Patrick''s'
Name LIKE 'St. Pat%' or even Name LIKE 'St. Patrick%s'
Some MS SQL database admins replace the apostrophe in the database.