function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vishal_ThoriyaVishal_Thoriya 

How to use Not Like comparison operator in Salesforce Database Query

hi,all

 

Following is the sql database query.

 

SELECT * FROM suppliers WHERE supplier_name not like 'T%';

 

but i want to achieve in salesforce.

 

How can i achieve it ?

 

Any kind of help will be greatly appriciated.

 

Thanks in advance

Vishal.......

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,
  You can use the below code to get your requirement.


List<account> ac=[select Id, Name from Account where (NOT Name like 'T%')];

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.