I have found this answer useful: Accent and case insensitive COLLATE equivalent in Oracle, but my question is regarding LIKE searching with a version 9 Oracle db.
This SELECT finds Kelly as expected: select [First Name], [Last Name], Phone from [Data$] where [First Name] like \"%Kelly%\"