SELECT *
FROM Verified.AccreditationStatus
WHERE IsCancelled=0
AND
(CASE WHEN ISNULL(@Status, '') <> ''
	  THEN CASE WHEN AccreditationStatusID IN(SELECT Value FROM
	  System.Fn_GenSplitCSV(@Status, ','))
			  THEN 1
			  ELSE 0
		   END
	  ELSE 1
END) = 1
ORDER BY Title