7 Replies Latest reply: Dec 2, 2013 8:23 AM by Srikanth P RSS

    IsNull(MyField)  vs. Len(MyField) = 0

    Bill Markham

      Hi

       

      IsNull(MyField) and Len(MyField) = 0 seem to do pretty much the same, as in they can both be used to check if a field is empty.

       

      Does anybody know if they are fully interchangeable or are they in some way different ?

       

       

       

      Best Regards,     Bill