I using Salesforce (apex), I need to Query with a WHERE statement with toLowerCase ,i.e. I have a list (MyNames_list) with LowerCase values but the table values are not lowerCase.
In my Query when I check the Name in MyNames_list it will make toLowerCase value and then check it in the MyNames_list.
Something like this:
Name | LastName
BOBY | Testovich1
DANY | Testovich2
Ron | Testovich3
and in my list:
MyNames_list :boby,dany,ron
That still will return me all rows, because WHERE statement will check it with LowerCase.
//only example (not working code)
for(Users user:[SELECT Name,LastName FROM Users
WHERE ( Name.toLowerCase() IN : MyNames_list) ] )
{
//code....
}
Is there a way to do this in Salesforce (apex) Query ?