I have an sql query with a few parameters. If one of these parameters is 0 I want to use a different where clause.
I'd to this like this
If @Param = 0
--SQL here with where clause
--SQL here with another where clause
My question is this, can this be done in a single SQL statement with say a CASE When in the where clause?