About this question
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?
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?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on Aug 29, 2023
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:
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce How to Get Into Salesforce With No Experience
Wondering if you can get a Salesforce job with no experience? Learn how to pick a career path, build real skills, and land your…
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…
Salesforce How to Become a Salesforce Admin With No Experience
No Salesforce Admin experience? Learn how to build real skills, create projects, and land an entry-level Salesforce Admin job…
Salesforce How Long Does It Take to Become a Salesforce Developer?
Wondering how long to learn Salesforce Developer? Most beginners need 6–12 months. See the study time, stage-by-stage roadmap and…