quoting a comma separated list

Hi

I have a comma separated list that has 1 or more elements

something like  

my $list = "One,Two,Three";
or
my $list = "One";

Select all Open in new window

when  printed I need $list to look like this

'One','Two','Three'

Select all Open in new window

eventually it will form part of a sql query thus

my $sql = "select * from table where stuff IN ($list)"; ## only to illustrate

Select all Open in new window

what is the quickest way of doing this?