SOQL LEFT() RIGHT() SUBSTR() operators
Apex & Visualforce,
Web Services API,
Large Enterprise Ideas,
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
3 years ago
2 years ago
1 year ago
11 months ago
10 months ago
One Market St.
San Francisco, CA 94105
If you still can't find what you're looking for, try to submit a case.
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.