CF & SQL Srvr - Call SP with list have SQL use IN @thelist

Essentially i have a group of checkboxes that have the same name.  I want to pull the records back from the database based on what boxes the user clicks, ie one or more than one box...but i cant figure out how to pass the comma delimited form variable to the stored procedure and have the stored procedure process the WHERE ... IN statement.

I want to have the stored procedure return records if the form were to pass in a "t" for searchlist or "t,b" for search list.  It seems to work ok if just the "t" is sent in, but the stored procedure does not work if the comma delimited list is passed in.  To use the IN keyword in SQL it needs to look like this:

WHERE   thetable.thefield IN ( 't', 'b')

but i cannot get the passed in parameter to work.  

I tried to do this in the stored procedure but its not reading it in the statement correctly.

IF @searchlist = 't,b'
BEGIN
     select @searchlist = " 't' , 'b' "
END

The t, and b are coming from checkboxes that have the same name, and therefore I want to pull all the records for the checked boxes.

it seems the double quotes are throwing it off


*** ColdFusion Stored procedure call: ***
<cfstoredproc procedure="sp_search">
     <CFPROCPARAM type="IN" cfsqltype="CF_SQL_VARCHAR" value=#Form.mylist# dbvarname="@searchlist">
</cfstoredproc>


*** SQL Stored Proc: ***
CREATE PROCEDURE sp_search
@searchlist varchar(100)
AS
DECLARE @err_msg varchar(100)

SELECT     *
FROM       thetable
WHERE   thetable.thefield IN ( @searchlist)  
     
RETURN(0)
GO

SQL Table [thetable]:
thefield  varchar(1) possible values [t,b,v]Start Free Trial