I want to query for accounts based on what the user types in a text field but rather than being totally dependent on the user to come through and type it correctly (lower or upper case) what I want to do is query the right opportunities with names that are equal in upper case.
This is what I have but you can't do this
List<Account> temp = [Select Name,ID,LastModifiedByID from Account WHERE Name.toUpperCase =: searchField ORDER BY LastModifiedDate Asc];
For ex. User enters "Hello" (name of opportunity is HeLLo) What I want to do is query it in a way that I compare HELLO and HELLO so I return the right results.
I'm not sure if this is possible. Another way I thought was querying all opportunities and comparing within a loop but that will be outrageous when I have a large number of records to process