Another good way is to have the index be UPPER(field1). Then when seeking just use the UPPER function on what you are seeking with. This ensures that your index is not going to be case sensitive.