How to query all leads to soql length of string?

202    Asked by Aalapprabhakaran in Salesforce , Asked on Aug 29, 2023

What should I do to query all leads with the length of city__c > 20 characters in SOQL or to get the SOQL length of string? Is there something missing in my documentation, as I cannot see anything like a length() in SOQL?

 I would suggest that you create a formula field of type NUMBER and then insert a simple formula into it that can calculate the length of the string. Like below:

Your Answer


Parent Categories