Avoid Case sensitivity in validation formulas - Answers - Salesforce Trailblazer Community
Ask Search:
Himanshu SharmaHimanshu Sharma 

Avoid Case sensitivity in validation formulas

Hey i have written a formula and in this i have to make the values case insensitive

OR( AND( Name  <>  "SGVU",Name  <>  "SSGVU"),
     AND(Website__c  <>  "aa" ,Website__c  <>  "abc") 
)
 
Best Answer chosen by Himanshu Sharma
Amnon KruviAmnon Kruvi
You can use the UPPER() and LOWER() functions to compare only uppercase or lowercase versions of the text. For example:
OR(
    AND(UPPER(Name ) <>  "SGVU", UPPER(Name ) <>  "SSGVU"),
    AND(LOWER(Website__c) <>  "aa", LOWER(Website__c) <>  "abc") 
)

Usually you'd stick with either UPPER or LOWER, but not both - I just wanted to give you both examples :)