> > You're assumption is wrong then, NULL isn't treated as not passing a > value. The reason it worked with substr was by pure chance. >
Out of interest, is there a reason that that is the case? Surely passing null would be best treated as the same as passing nothing?