Select where case

Are you looking for this?

SELECT *
FROM iv00101
WHERE USCATVLS_2 = '' OR USCATVLS_2 IN (@category)

---

A Fan of SSIS, SSRS and SSAS