how do I insert an apostrophe

This seems like it should be simple but I'm stumped. How can I insert a name with an apostrophe into a table? I've tried double quotes but get the error "column not allowed here".

INSERT into EVENTS VALUES ( 'Info', 'More Info', "O'Brien")

TIA

--
Randy Harris
harrisr at bignet dot net