26 February 2007

lnnvl() ftw

Courtesy of Jonathan Lewis, I present you with LNNVL(). For those of you who forget to consider the possibility of NULL values in your query predicates, this could be a godsend. Should clean up a lot of predicates that had to use OR cases just to separately check for NULLs.

As Jonathan describes it: "The function lnnvl(predicate) returns true if its parameter returns false or null."

No comments:

Post a Comment