Of course.

Here's an outline of how the stored procedure could look. One should probably add more (better say any;) ) input verification, but--as far as I've tested it--it works correctly.

You...

Am I missing something or does the script mishandle nulls?

Basically, it's always generating "where x = isnull(y, 0)" comparisons which evaluate true for x=0 and y=null.

Paul White has a great...