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
vanessa veronvanessa veron 

Case sensitive SELECT

Hello!
I want to compare if a variable has the same name as one of the values ​​of my custom object.
I would like to delete the same values...

I could add as nameJob__c: JOB, job, Job (three different things).

Is to do a select informing CASE SENSITIVE??

List<obj__c> existing = [SELECT Id From obj__c where nameJob__c =:NameJobSchedulable];
delete existing;
NameJobSchedulable = variable String

Thank you
Best Answer chosen by vanessa veron
Ramesh KallooriRamesh Kalloori
no soql is not case sensitive.

{
   String x='Google';
List<Contact> c=[SELECT ID  from contact where LastName=:x];
   Delete c;
}

the above query delete the Contact with name as google.

thanks,
Ramesh

All Answers

Ramesh KallooriRamesh Kalloori
no soql is not case sensitive.

{
   String x='Google';
List<Contact> c=[SELECT ID  from contact where LastName=:x];
   Delete c;
}

the above query delete the Contact with name as google.

thanks,
Ramesh
This was selected as the best answer
vanessa veronvanessa veron
Thank you!!!!