Re: Case Sensitivity

Check the FAQ. One solution is to upgrade to version 7.3 of the engine which have this support built in. Just be aware that you can't create an index in that version that is used in such cases. For that you would need the Universal Data Option (version 9.1x of the engine). Another solution is to create an extra field containing an all lower case version of what you want to search for. That can be indexed and therefore be fast both for querying ans sorting. It may however be hard to maintain as it must be done in your application (at least with 7.3x or lower versions of the engine). The FAQ have some stored procedures you can use, but the performance is a significant question. On Thu, 13 Aug 1998 10:57:27 -0500, Kevin Calcagno <kcalcagn@tellabs.com> wrote: >Can anyone tell me how to overcome case-sensitivity when doing a select >query such as: > >SELECT * FROM docs >WHERE subject like '%data%';> >... without having multiple OR... clauses with every combination of >capital and non-capital letters? > >Thanks in advance, >Kevin Calcagno > >-- >/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\ >Kevin M. Calcagno 6020 Oakwood Drive Apt. 5M >calcagno.1@nd.edu Lisle, IL 60532 >http://www.nd.edu/~kcalcagn Phone: (630)435-6557 >Work: kcalcagn@tellabs.com Work: (630)378-8602 (ext. 2-8602) >\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/ Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)