isnull in where clause
Posted on 2010-11-30
I want to put the following code in my query where statement: isnull(criteria,'1=1').
the critieria will either be something like "Age < 18", "Age > 18", etc, or NULL. I would love for there to be a SQL eval statement but there is not. also i want to stay away from dynamic SQL.......is thre anything that i can do here or do i have to go to dynamic SQL?