SQL - Stored Procedure with Select Statement using

Question

I am creating a stored procedure to which I want to pass as variable a comma delimited list of Ids. I want to use the Ids into a select statement, something like:

Create Procedure up_TEST
@Ids VARCHAR(MAX)
AS
SELECT * FROM ATable a
WHERE a.Id IN(@Ids)

Obviously I get the error that @Ids is a varchar and not an INT but how can I convert the comma delimited list?

Answer 1

CREATE PROCEDURE PROCEDURENAME
@Id Numeric(18,0)
AS
BEGIN
    SELECT * FROM tableName
    WHERE tableName.Id IN (@Id)
END