Hi,
In your case you have to use Dynamic Query... for example
CREATE PROCEDURE ProListLoc
@LocIDs VARCHAR(100)
AS
BEGIN
DECLARE @SqlQuery VARCHAR(1000)
SELECT @SqlQuery='SELECT * FROM TableName WHERE LocationID IN('+ @LocIDs +')'
PRINT @SqlQuery
EXEC (@SqlQuery)
END
EXEC ProListLoc @LocIDs = '10,15,20'
Regards,
GVPrabu