What is the best way to do fast search by first name or last name etc?

Interbase or Firebird does not use index if you uppercase(firstName).

This is driving me crazy.

jw