Re: Apostrophe in SQL*Plus string

Alan Screen wrote:
>
> I'm trying to use an apostrophe as part of the search condition
> in a select statement - e.g.,
 ...
> However, I'm can't seem to find the syntax for <desc_clause> which
> would allow me to search for "Alan's%", because there is an apostrophe
> in the string - i.e.,
> SELECT name FROM mission WHERE description LIKE 'Alan's%'
> has too many apostrophes. Any ideas on how to do this?

No, not _too many_ but _to few_ apostrophes!!!

SELECT name FROM mission WHERE description LIKE 'Alan''s%'

In SQL*Plus you have to use two apostrophes to get one!

Happl from Switzerland Received on Fri Oct 17 1997 - 00:00:00 CEST