Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: quotes problem

Re: quotes problem

From: Samuel Leung <m2624526_at_netvigator.com>
Date: Wed, 25 Aug 1999 10:40:19 +0800
Message-ID: <7pvjsm$v36$1@imsp009a.netvigator.com>


The second one should work. But you must be sure that the string is completely match
if you are using equal sign. Try LIKE '%....%' instead.

siddsoni_at_hotmail.com wrote in message <7puasj$198$1_at_nnrp1.deja.com>...
>I want to execute this SQL:
>select * from store where name = 'John's Used Cars'
>
>I also tried:
>select * from store where name = 'John''s Used Cars'
>
>Neither works. What am I supposed to do?
>Thanks.
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Aug 24 1999 - 21:40:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US