Then you have to convert your fields with UPPER(), LOWER() or PROPER(). So to optimize, you have to index using upper, lower, proper if any of these are used in the WHERE clause --
select all id, upper(lname) lname, upper(fname) fname ...
Mark McCasland
Midlothian, TX USA