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
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