Re: Help - SQL update of character field in table

Problem solved......

Thanks to all who responded by email and in the group. Using 2 single quotes '' worked.

Steve

In article <7vOX1.90$sE6.410121_at_NewsRead.Toronto.iSTAR.net>, agnews_at_inforamp.net says...
>
>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 Sat Oct 24 1998 - 00:00:00 CDT