In the simplest scenarios, you would use the case statement in either of two ways:
1 - modify the contents of the WHERE clauses
2 - create a query from component data as implied by the case as a string and then EXEC the query.
If you need help in how to use case statement, consider
https://msdn.microsoft.com/en-us/library/ms181765.aspx[
^]