Apostrophe in SQL*Plus string

From: Alan Screen <alans_at_array.ca>
Date: 1997/10/17
Message-ID: <EI7Es7.tu_at_array.ca>#1/1


[Quoted] [Quoted] I'm trying to use an apostrophe as part of the search condition in a select statement - e.g.,

        In the description field of a record I have the following string:

                        Alan's sample description

        and I'm trying to do a query like

                SELECT name FROM mission WHERE description LIKE <desc_clause>

[Quoted] 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?


Alan Screen                    | Phone:  (416) 736-0900 ext. 287
Array Systems Computing Inc.   | Fax:    (416) 736-4715
1120 Finch Ave. W, 8th Floor   | E-mail: alans_at_array.ca
North York, ON   M3J 3H7       |         alan_screen_at_acm.org
Canada   (eh?)                 |         alan_screen_at_computer.org
http://www.array.ca            | "I'd rather be snowboarding!!"
Received on Fri Oct 17 1997 - 00:00:00 CEST

Original text of this message