Difference between ISBLANK and ISNULL

Difference between ISBLANK and ISNULL

ISBLANKISNULL
Determines if an expression has a value and returns
TRUE if it does not. If it contains a value, this function returns FALSE.
Determines if an expression is
null (blank) and returns TRUE if it is. If it contains a value, this function
returns FALSE.
Text fields cannot be null. So use mainly for text fields.Numeric fields cannot be blank. So use mainly for numeric fields.

Leave a Reply