I'm trying to construct a query that will return company names using a SELECT query. My problme is that some companies have an apostrophe in the name. Is there a way to have a single query return companies with or without an apostrophe in the name? For eample:
SELECT * from [employers] where company LIKE ''o'leary%"
But want the query to return any matches that have an apostrophe or not. Another example: there are two companies in the employer table, one named Dunkin Donuts, and other named Dunkin' Donuts. These are in fact two separate employers with different locations, but I need the query to return both.