Case insensitive searches

[chuck hinkle]

I want to do searches that are case insensitive. What would you recommend?
Do I need to write a method that converts fields to all upper case, index
them, and do the search against them? Or, would you convert all fields to
all upper case as they're stored in the database? I really don't like the
second option because I want to display the records back to the users to
select.

chuck