Re: Help - SQL update of character field in table

Try using two single quotes (NOT a double quote) when you want to insert a quote, eg:

    update tablex set description='Up Miller''s creek' where ...

Steve Agnew wrote in message
<7vOX1.90$sE6.410121_at_NewsRead.Toronto.iSTAR.net>...
>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