How do I setup a query while looking for a record with an apostrophe in it?

Question

How do I setup a query while looking for a record with an apostrophe in it?

Answer 1

You just quote it with a ‘

select *
FROM tbImacoonew
WHERE [COMPANY NAME] like 'Andersen''s Industries Inc'