This is a GREAT discussion!
I find myself more and more in agreement with the idea that:
SUBSTR($X,"") should always return 0.
As was mentioned before, the value returned is an index of the first instance of the 2nd string passed to the function. Even if using set theory causes us to say that the null set is in anything, the value indexed as 1 can never be equal to an empty string.
Brian
|