how to deal with '

[dragon99]

Hi, all
Could anyone tell me how to deal with '
for instance:
insert into tablename values('macy's');
Thanks for help.

[m1l]

Just put two quotes, so it would be

insert into tablename values('macy''s');