-
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.
