Help - SQL update of character field in table

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 Thu Oct 22 1998 - 00:00:00 CDT