I'm new, but curious.

Would "WHERE table.col = IsNULL(@varName, table.col)" do the trick?

Thanks for your feedback,

David