I want to be able to search for text within fields and select records even if the case is not the same (i.e. "Joe" = "joe"). The only two methods I have come up with is to add fields to the tables where the data to be searched on has been made into all upper or all lower case and convert the text being searched for into the same case or use the upper or lower functions on both the fields and the text to be searched. Neither option is a good one. What I would like is to be able to create an index which converts all text to one case. Is there any capabilities in Oracle which assists with this problem? Received on Tue Jan 13 1998 - 00:00:00 CET
Original text of this message