4 Replies Latest reply: Oct 16, 2017 2:26 PM by Sunny Talwar RSS

    Which is safe? isnull() or Len()>0

    Vishnu Chakravaram



      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?