Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

SELECT * FROM table1 WHERE fieldStatus IN (@Status) AND (CASE WHEN @Status = 'Open' AND COUNT(@Status) = 1 THEN fieldDate >= GETDATE() END) I hope that makes sense. Anyone know how to test for a multi ...