Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
I understand '00' is a null value. Please advise.
A common mis-understanding. . .
x'00' is also known as low-values, hex zeros, and binary zeros. All of which are values. NULL is the absence of any value. The condition may be tested (i.e. IS NULL), but there can be no compare for some value that is null.