+ Start a Discussion
WPCMSWPCMS 

What is the difference between ISNULL and ISBLANK?

I am not sure which function should be used between ISNULL and ISBLANK.

 

Can anyone describe this for me?

 

Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

All Answers

JohanLiljegrenJohanLiljegren

This is very well described in the Help & Training area. Simply search for isblank or isnull to find it.

 

To put it short, use ISBLANK(). =)

SteveMo__cSteveMo__c
This was selected as the best answer
vijayabakarareddy yarrabothulavijayabakarareddy yarrabothula
Text fields are never null, that means even if you didn't provide any value ISNULL()  function  takes empty as a value.
  so using ISNULL() with a text field always returns false.
 For example, the formula field====  IF(ISNULL(new__c) 1, 0) is always zero regardless of the value in the New field.

For text fields, use the ISBLANK function instead.
  IF(ISBLANK(new__c) 1, 0)   true if if has a value 
  IF(ISBLANK(new__c) 1, 0)    false if it don't have a value