How i pass multiple values into the where condition column ?

See more:

SQL-Server

Hi,

I have a query and want to pass multiple column values as a parameter.

for example i have below qquery where i want to pass multiple values instead of one value-

SELECT DISTINCT prs.RiderId
 
FROM [dbo].[PlanRiderSet] prs
 
INNER JOIN [dbo].[PlanProductSet] pps
 
ON prs.PlanId = pps.PlanId
 
inner join [dbo].[PlanRider] pr
 
on pr.Id=prs.RiderId
 
WHERE pr.RiderIdNumber=604 /*Here I pass value like multiple means ‘604,601,605,703’ like this values are in table column values.*/
 
and pps.ProductId = (SELECT pps.ProductId
 
FROM [dbo].[CustomerXref] cxref
 
INNER JOIN [dbo].[CustomerPlanXref] cpxref
 
ON cpxref.Id = cxref.PlanXrefId
 
INNER JOIN [dbo].[Plan] p
 
ON p.Id = cpxref.PlanId
 
INNER JOIN [dbo].[PlanProductSet] pps
 
ON p.Id = pps.PlanId
 
WHERE cxref.PlanXrefId = 3598)
 
ORDER BY prs.RiderId

How do I achieve this [Edit - shouting removed]