Re: apostrophes in an SELECT SQL statement

From: Hema Krishnamoorthy <hema_at_teldta.com>
Date: 1996/07/19
Message-ID: <31EFCD3E.46B9_at_teldta.com>#1/1


Rajiv Tandon wrote:
>
> 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.

Hi,

Even I agree to the above reply . It is wnough if we use double single quote . It is not necessary to use so much of the quotes as in the other reply.

Hema. Received on Fri Jul 19 1996 - 00:00:00 CEST

Original text of this message