[dba-SQLServer] Ho To: Create a Stored Procedure using a parameter for IN

Sometime I think I go brain dead.  ;-)

I am trying to do a stored procedure with a simple SQL statement
like:

SELECT ClientID, LastName, FirstName, ResidenceType
FROM tblClient
WHERE ResidenceType IN(@ResType)

I need to be able to pass something like:

house, hotel, homeless

and get a list of people with that residency type.  Nothing I have
tried has worked.  Can anyone give me some direction on doing this?

Thanks,

Robert L. Stewart
The Dyson Group
Expanding your sphere of Knowledge