If uncleharryind is varchar, check for the null string (''). I was quite surprised to discover that null string isn't treated
as a null value, but as a character string of zero length.
You probably worked with Oracle before ;-)
This is known bug in Oracle's implementation of Varchar2.