Re: apostrophes in an SELECT SQL statement

Jason Byors wrote:

> How could the following SELECT SQL statement be written so that it
> will work:
>
> SELECT * FROM movies WHERE title = 'Muriel's Wedding'

Use a double single-quote i.e.

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

Rajiv Tandon
The Phoenix Project
BellSouth

All opinions are mine etc. Received on Thu Jul 18 1996 - 00:00:00 CEST