Explore Courses Blog Tutorials Interview Questions
0 votes
in Salesforce by (11.9k points)

Following is example of SQL database query


FROM suppliers

WHERE supplier_name not like 'T%';

This query will returns the records where supplier_name does not starts with T

But how can I achieve the same functionality in salesforce?

1 Answer

0 votes
by (32.1k points)

There's no select *, so you have to specify the exact fields to query, you'd then use NOT and LIKE, e.g.

SELECT id,name, otherFields from suppliers where NOT supplier_name like 'T%'

Browse Categories