apostrophes in an SELECT SQL statement

How could the following SELECT SQL statement be written so that it will work:

SELECT * FROM movies WHERE title = 'Muriel's Wedding'

The apostrophe in the word Muriel's is not allowing this statement to be processed. Is there any way to make such a statement work, or would I have to remove all the apostrophes from my table?

Thank you for your help,
jb Received on Thu Jul 18 1996 - 00:00:00 CEST