Passing In Array Like Variables T-SQL

IF you SQL Server IS >=2008 then:

USE tempdb;
GO

CREATE TABLE voilets
    (cfrw char(3), DSCA int)
go
INSERT INTO voilets VALUES ('R02', 2)
INSERT INTO voilets VALUES ('F16', 5)
INSERT INTO voilets VALUES ('F16', 4)
INSERT INTO voilets VALUES ('X77', 9)
go
CREATE TYPE myType AS TABLE (id CHAR(3));
GO
CREATE PROCEDURE usp_myProc
    @default char(3),
    @voiletsTVP myType READONLY
    AS 
select * from voilets 
where cfrw = @default
UNION 
(select * 
from voilets
where cfrw in (SELECT * FROM @voiletsTVP)) 
ORDER BY DSCA
GO
-------------------------
DECLARE @default char(3)
SET @default='F16'
DECLARE @voiletsTVP AS myType;
INSERT INTO @voiletsTVP SELECT * FROM (VALUES ('B05'),('B12'),('R02'),('F01'),('F16'),('F17'),('U11'),('U03'),('U04'),('U21')) q(x)
EXEC usp_myProc @default,@voiletsTVP
GO

Result-set:

cfrw    DSCA
R02     2
F16     4
F16     5

Performing that safely in a sproc is actually quite tricky; there are a few common approaches:

• use a udf to split a string on a token - google for "split udf" (there will be many), and join on the results
• use a table valued parameter

Personally, I rarely use sprocs these days; I'd use dapper:

List<string> foo = ...
var items = conn.Query<SomeType>(
    "select * from [table] where colName in @foo", new { foo }).ToList();

Most LINQ providers and ORMs will have options here too, involving Contains etc.

You can learn about Passing Arrays in SQL Parameters using XML Data Type in SQL Server 2005

See sample:

/* for this xml:
<list>
    <item>42</item>
    <item>73</item>
    <item>2007</item>
</list>
*/

CREATE FUNCTION [lm].[SplitList]
(
    @list AS XML
)
RETURNS TABLE
AS
RETURN
(
    SELECT tempTable.item.value('.', 'VARCHAR(MAX)') AS Item
    FROM @list.nodes('list/item') tempTable(item)
);

Why not use a sql CLR function to split your values, passing those into your procedure. Here is a very good and fast split string implementation: CLR Split String. If you can't use sql clr, then look online for 'sql split string'. Whichever you use you put the result of that work into a temporary table and join that to your main table.