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

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

    Vishnu Chakravaram

      All,

       

      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?