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 Entry-Level Salesforce Admin Salary: What Can You Expect to Earn?
Curious what an entry-level Salesforce Admin actually earns? See real salary benchmarks by experience and location, plus how to…
Salesforce Senior Salesforce Admin Salary: Salary Range, Factors & Career Growth
What does a senior Salesforce administrator actually earn? See real salary ranges, the skills that boost pay, and how to move up…
Salesforce Cost of Salesforce Developer Certification: Exam Fees, Retakes & Hidden Costs
The cost of Salesforce developer certification is $200 per exam and $100 to retake. See taxes, discounts, hidden costs, and…
Salesforce Cost for Salesforce Certification: Exam Fees by Type, Retakes & Hidden Costs
Salesforce certification exam fees run $75 to $4,500, and most cost $200. See cost by role, retakes, taxes, discounts, and…