title: Salesforce(apex) Query select with Where toLowerCase
body: <p>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.</p>
  
  <p>In my Query  when I check the Name in MyNames_list it will make toLowerCase value and then check it in the MyNames_list.</p>
  
  <p>Something like this:</p>
  
  <pre><code>Name | LastName
  
  BOBY | Testovich1
  
  DANY | Testovich2
  
  Ron  | Testovich3
  </code></pre>
  
  <p>and in my list:</p>
  
  <blockquote>
    <p>MyNames_list :boby,dany,ron</p>
  </blockquote>
  
  <p>That still will return me all rows, because WHERE statement will check it with  LowerCase.</p>
  
  <p>//only example (not working code)</p>
  
  <pre><code>for(Users user:[SELECT Name,LastName FROM Users 
                  WHERE ( Name.toLowerCase() IN : MyNames_list) ] )
  {  
      //code....
  }  
  </code></pre>
  
  <p>Is there a way to do this in Salesforce (apex) Query ?</p>