Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

whats the difference between isblank and isnull?

April 26, 2017difference isnull

0

Posted

whats the difference between isblank and isnull?

1 Answer

0

Posted

Use ISBLANK and BLANKVALUE to determine if fields of any type (except picklists) are empty. In previous releases, you had to use different functions depending on the data type of the field. For example, you could use ISNULL and NULLVALUE to determine if an email was empty, but you had to use LEN()=0 to determine if a text field was empty.