Pass multiple value for 1 SQL parameter

See more:

SQL-Server-2005

SQL-Server

C#3.5

Hi. This is my procedure

create proc temp @value nvarchar(max)
as
begin
    DECLARE @sql nvarchar(max)
    set @sql = N'Select * from dbo.Categories
    where CategoryName in (' + @value +')';
    print @sql
exec sp_executesql @sql

end

I can pass multiple value for @value like this and it works

temp @value = '''Beverages'',''Condiments'''

In my window form, I have multiple check boxes, for example if checkbox 1 & 2 were check:

value = "'''"+cb1.Text + "'',''" +cb2.Text + "'''" 

and pass it through SQL parameter, but it doesn't work.It doesn't throw any exception but doesn't return anything either.

Any help was appreciated.