Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Smile Unanswered: What is the difference between NULL and EMPTY

    What is the difference between NULL and EMPTY in access table?
    I've tried some function in access query, eg. IsNull(..) for checking any empty field.

    but is it the same to use IIF ([field]="",...) ??

    Thanks in advance ^_^

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    nz(fieldName, "")
    converts Null to zero length string. then you can use something like
    len(nz(fieldname, "")=0
    to handle nulls and zero-lengths at th same time

    "Empty" has a specific meaning - applies only to Variants

    whether your field holds Null or zero-length strings? search help for "Required"

    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts