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: HELP: Embedded characters in SQL statement

Re: HELP: Embedded characters in SQL statement

From: Grue <grue_at_stopspam.hotmail.com>
Date: 1998/02/12
Message-ID: <34e376f8.30479054@128.158.254.10>#1/1

You need to use two single apostrophes in place of the one, i.e., 'Wilson''s Products'. This will translate to Wilson's Products (one apostrophe) in the database.

On 12 Feb 1998 21:59:57 GMT, "Irene Westervelt" <iwesterv-no_at_span.mdsi.bc.ca> wrote:

>
>
>no_at_spam.allowed wrote in article
><MPG.f49162c463c4c769896e5_at_news.wwa.com>...
>> I would like to know how to submit an SQL statement which has imbedded
>> characters such as an apostrophe or quotation-mark in them. For example,
>>
>> SQL_Statement="Select * from myTable where companyName = 'Wilson's
>> Products'"
>>
>> As you can see, the word Wilson's contains an embedded apostrophe.
>>
>> Is there an acceptable method whereby I can submit this value without the
 

>> apostrophe causing a problem?
>>
>
>Hi I also experienced this problems and could not find a solution - at the
>end I made use of th ` sign. eg. Wilson`s instead of the single
>qoute(because Oracle sees this as a reseved word). If you can find another
>workaround please let me know.
>
>Irene
>> I've tried this with Oracle via RDO and it fails on the statement because
 

>> of the embedded apostrophe.
>>
>> Please e-mail your solution if possible.
>>
>> Thanks....
>>
>> --
>> Bob
>> rhl_at_cadmandu.com
>>

Grue



Please remove "stopspam." from address to reply. Received on Thu Feb 12 1998 - 00:00:00 CST

Original text of this message

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