SQL & PL/SQL

Hi all,

I have a Insert statement as follows.

insert into mytable(description)
values('Spoon 'n Fork');

In order to have the single quote before the n, I can frame the sentence as follows,

insert into mytable(description)
values('Spoon ''n Fork');

But if the same comes in a sql script there many rows will have single quote as 'n.
How can I fix this?

any ideas

thanks
asp