Find the Partner Domain Contacts
Basic SolvedAcme is moving to a new email platform, and IT wants every contact who has an acme.com address.
Return LastName and Email for every Contact whose email address ends with @acme.com.
Sample data
Contact 4 records
| LastName | |
|---|---|
| Rao | [email protected] |
| Singh | [email protected] |
| Patel | [email protected] |
| Iyer | [email protected] |
Expected result on the sample
| LastName | |
|---|---|
| Rao | [email protected] |
| Iyer | [email protected] |
Row order does not matter. Only the columns above are compared; extra columns in your SELECT are fine.
Hints
%matches any number of characters.- Include the
@in the pattern.
What this tests
LIKE with % handles prefix, suffix and contains matches, and it is case-insensitive. Anchoring the pattern on @acme.com instead of acme.com matters: without the @, addresses like notacme.com match too. Leading wildcards cannot use an index, so on large objects pair them with a selective filter.
Datasets
Solved on this device only. Sign in with Google to keep your progress across devices.
Run on sample executes your query against the sample data shown on the left and displays the rows it returns. Submit checks it against the sample plus 2 hidden datasets, comparing your rows with the expected rows on each. Queries run in a real Salesforce org; the data is inserted for your run and rolled back afterwards.