Re: apostrophes in an SELECT SQL statement

Jason Byors <jbyors_at_ssi.sony.com> wrote:
>How could the following SELECT SQL statement be written so that it
>will work:
>
>SELECT * FROM movies WHERE title = 'Muriel's Wedding'
>

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