eg Peter's
if one passes the name to an sql in code it ends up looking like:
insert into whatevertable (name) values('Peter's');
and bombs.
Any suggestions appreciated.
Richard