-
how to use wildcards for Soql in salesforce?
Hi,
I don't understand about wildcards:
Please can you explain me ( with example of words)
1 Select id from Account where Name LIKE ' %Dir%'
2 Select id from Account where Name LIKE ' Dir%'
3 Select id from Account where Name LIKE ' Dir_%'
thanks
-
1 Reply
-
Hi Vikas,
The % and _ wildcards are supported for the LIKE operator.
- The % wildcard matches zero or more characters.
- The _ wildcard matches exactly one character.
For example in your case, if the accounts in your org have the following names:
{Direct, ReDirector, UnDirects, UnDir, Dir}
The first query returns: Direct, ReDirector, UnDirects, UnDir
The second query returns: Direct, Dir
The third query returns: Direct
Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Shifting Mindsets for Success – From Consultant to Solution Architect
The consultant role is known for its significant value in the business landscape. Such professionals bring valuable insights and new perspectives to organizations looking for…
Salesforce vs Zoho CRM - Make a Decision with this Comprehensive Comparison
Is Salesforce or Zoho CRM a better fit for your company? We're here to assist you in making a decision with our comprehensive comparison of…
6 Best Practices While Implementing Salesforce Sales Cloud
Sales Cloud is one of the most prominent offerings in the Salesforce ecosystem and has a proven track record of transforming the sales pipeline and…
Popular Salesforce Videos
Salesforce Service Cloud Einstein Bots
Learn how to set up and use Einstein Bots to increase case deflection and reduce service costs through self-service. This webinar gives you a guided…
Introduction to Salesforce CMS
Salesforce CMS is a hybrid content management system, where you can curate and share content, manage multiple language versions of your content, and control who creates…
Approval Process In Salesforce | Salesforce Development Tutorial
Approval process in Salesforce. This video will cover the following points - 1. Approval Process Learn how to create an approval process. 2. Manage Approval…
