apostrophe in a string

how can I insert an apostrophe?
as in
insert into dummy values('jane's cat','meow');

i tried
insert into dummy values('jane\'s cat','meow');

but this did not work. any help is appreciated.

thanks,
son

--
"Challenge the known and embrace the unknown."
				-another fortune cookie
Son To
http://www.seas.upenn.edu/~son