To get a dynamic where clause you would need to use dynamic sql and execute that sql string.

Or you could have both queries and an if else statement. Based on the conditions you provide, either one or the other query will be executed.