casting values SQL IN function

See more:

ASP.NET

SQL

Hello,

I have this problem where I am passing nvarchar parameter to a stored procedure, and the field type in the table for that parameter is int. I am doing that because I am using IN function, and for example if I want to send multiple parameters, that is the only possible way to do through .NET. Or not? The SP doesn't get executed because of the wrong type, and I am trying to cast the value, but I get an error. Here is how I am trying:

Example: @Parameter nvarchar OrderStatusID = ('30, 40')
(o.OrderStatusID IN (CAST(@OrderStatusID as int)) OR @OrderStatusID IS NULL)

Is there a way to cast each value separately, or what will be the best way to cast whole value as int. Thanks in advance for your help