The questions is not clear. If you meant to ask how to pass multiple values in a parameter passed to SQL Server Stored Procedure, you can actually pass it as a bitfield and use bitwise AND operator (&) in T-SQL to get the value. Check this
article[
^] to know more.
If you meant to ask how to check for multiple values in a column, you can use the IN clause
SELECT * FROM MyTable WHERE DayOfWeek IN ('monday', 'thursday', 'friday')