The case sensitiveness is a limitation on the database. Oracle by default is case sensitive and you need to change its configuration to make it case insensitive, but you need to recreate your indices. You can do a search on this forum for more information if it is workable. However MS SQL server is case insensitive, so your queries would work in either case. With oracle I think you could use remedy FullTextSearch feature to run case insensitive queries for specific fields. And it is free feature to use. Otherwise as Tauf has suggested you need to convert the data to uppercase before saving the record and any time doing a query, convert the user entered data to uppercase to use with queries. With the newer versions of arsystem there is a type ahead feature you can enable case insensitive. See if it would be useful in your case.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
