I would use Jeff Moden's DelimitedSplit8K function to do this:

First create some sample data:

IF OBJECT_ID('tempdb..#Cars') IS NOT NULL

DROP TABLE #Cars

CREATE TABLE #Cars (

[ID] INT IDENTITY(1,1) NOT NULL,

[CarBrand] VARCHAR(10) NULL,

[CarYear] INT NULL,

PRIMARY KEY (ID))

INSERT INTO #Cars

SELECT 'Chevrolet',2003 UNION ALL

SELECT 'Ford',2005 UNION ALL

SELECT 'Toyota',2006 UNION ALL

SELECT 'Ford',2012 UNION ALL

SELECT 'Saturn',2008 UNION ALL

SELECT 'Honda',2005 UNION ALL

SELECT 'Chevrolet',2004

SELECT * FROM #Cars

This is how to filter using DelimitedSplit8k:

DECLARE @test-2 AS VARCHAR(90)

SET @test-2 = '2003,2004,2005'

SELECT

c.CarBrand

,c.CarYear

FROM

#Cars c

INNER JOIN

dbo.DelimitedSplit8k(@Test,',') as dsk

ON c.CarYear = dsk.Item

Output

CarBrandCarYear

Chevrolet2003

Chevrolet2004

Ford2005

Honda2005