apostrophe in Oracle field

There must be someone encounterred and have a solution to this problem:

When you have a " ' " (apostrophe) among some text data in a table field,
it causes trouble when you do, for example:

> select * from table where name='O'Brian':

ERROR:
ORA-01756: quoted string not properly terminated

Any general approach to avoid this?

Thanks in advance!

Zhiliang Received on Tue Apr 24 2001 - 16:10:01 CDT