insert with "Fred's car!"

Hi,

A simple question :

How can I insert a values like

insert into tablename values('Fred's car');

I've tried "Fred's car", 'Fred''s car', etc but nothing work.. is there a
"\something" to pass it like

'Fred\c' car'

?

THanks
\fb

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com