quote:

---

You can also use

Where

Col1 = @Param1

and (Col2 = @Param2 OR @Param2 Is Null)

and (Col3 = @Param3 OR @Param3 Is Null)

etc etc

When executing,...