Problem With This Kind Of Sql Statement WHERE ... IN (...,...,...)

Hi,





I have a problem in a Stored Procedure SQL query im writing, basically what I want is something that works like this





WHERE intField IN (@strCommaSepList_Of_Integers)





First I tried this:





SELECT idComp_Clie_Bran_User, strComp_Clie_Bran_User_FirstName, strComp_Clie_Bran_User_Surname


FROM dbo.tblComp_Clie_Bran_Users


WHERE (fk_idCompany = @fk_idCompany) AND (fk_idComp_Client = @fk_idComp_Client) AND (fk_idComp_UserGroup IN (@strListUserGroupsAllowed))





But if I passed a 25,26 value to the last paramenet is gave an error saying:





Syntax error converting the varchar value '25,36' to a cllumn of data type int.





How can I get this to work??





If for example I manually put the WHERE IN values it works, ike this I mean:





SELECT idComp_Clie_Bran_User, strComp_Clie_Bran_User_FirstName, strComp_Clie_Bran_User_Surname


FROM dbo.tblComp_Clie_Bran_Users


WHERE (fk_idCompany = @fk_idCompany) AND (fk_idComp_Client = @fk_idComp_Client) AND (fk_idComp_UserGroup IN (25, 36))





But thats no use as I have to pass the list of values dynamically...





Please help!!





- Carl