Salesforce(apex) Query select with Where toLowerCase
<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>