This content has been marked as final. Show 4 replies
I'm trying to suggest someone on how best to handle nulls.
In my experience, I have seen that not isnull() works fine but lately, I have seen it behaving weirdly.
So is it safe to say that len()>0 is a suitable replacement for not isnull() in where clauses?
Are there any exceptions/Caveats when with both approaches?