Re: HELP: Embedded characters in SQL statement

Wherever an apostrophe appears double it. Example:

Select * from myTable where companyName = 'Wilson''s Products'

That is 2 apostrophes (not a qote)

no_at_spam.allowed wrote in message ...
>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?
>
>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
>
Received on Mon Feb 09 1998 - 00:00:00 CET