Vote 1630  points

Ron Wild

SOQL LEFT() RIGHT() SUBSTR() operators

Salesforce Platform, Apex & Visualforce, Database Services, Web Services API, Large Enterprise Ideas, Large Enterprise

I'd like to see string operators like LEFT, RIGHT, SUBSTR available in SOQL expressions. Example: To find contacts matching a set of zip codes one could use the following SOQL statement: SELECT id, name FROM Contact WHERE LEFT(postal_code, 5) in ('92024','92028') This would enable search results to include Contacts with extended postal codes (e.g. 92024-1345)

6 years ago · 17 Comments ·Merge Idea · Report Abuse

1 to 10 of 17 | Next Page

Ideas

Apps

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce.com takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.