Re: Help - SQL update of character field in table

Hi,

Here's the solution:

     update tablex set description='Up Miller''s creek' where response=1

(Two characters of ' between r and s).

Regards

Steve Agnew wrote:

> I'm new to SQL Plus, so I hope this question isn't to stupid...
>
> I would like to know how to update a character field in a table when
> the
> information being added contains a single-quote.
>
> For example, the following works fine:
> update tablex set description='Up the creek' where response=1
> but
> update tablex set description='Up Miller's creek' where
> response=1
> comes back with an error.
>
> Is there some way to get around this problem?
>
> I would appreciate any assistance.
>
> Steve
Received on Fri Oct 23 1998 - 00:00:00 CDT