i have created one stored procedures and its work properlly i have showed you

select * from Demo1
where CONVERT(VARCHAR,id) in (1,2,3,4)

But when i am calling stored procedure form web application and pass values like this i have showed you

ALTER PROCEDURE [DBO].[SP_GET_DEMO_RECORDS] --'1,2,3,4'
(
@Records varchar(1000)
)
AS
BEGIN
SET NOCOUNT ON;
select * from Demo1
where CONVERT(VARCHAR,id) in (@Records)

END
GO

and i have comment values(1,2,3,4)

but when i am execute stored procedures its not show records

show how to get records...and i will pass unlimited values from user inetrface

but when i have pass 1 values its executted but when i have pass more than 1 values show its doesnot excutted.

so how to solve