you didnt read the rest of the message or my example. Its all very well using the sql lower function, but if you cant force the user to type the input in lower case you are wasting your time. However, I have now cracked it, as a later message to the group shows, but only in the report dtml, not in the sql method. See my web page for further details On Wed, 17 Jan 2001 22:13:51 +0100 (CET) Dieter Maurer <dieter@handshake.de> wrote:
Maggie Shapland writes:
How does one do a case-insensitive search using sql methods when the underlying database is case-sensitive? Oracle, e.g., provides functions "LOWER" and "UPPER" that you can use in SQL expressions. They can be used to implement case-insensitive searches.
Look at the list of built-in functions for your database.
Dieter
---------------------- Maggie Shapland, Computing Service, University of Bristol, Tyndall Av, Bristol BS8 1UD Tel: 0117-9289869 (Int 9869) Email: Maggie.Shapland@bristol.ac.uk Web page: http://www.cse.bris.ac.uk/~ccmjs/ 1925 Lanchester 21, 1925 Talbot 10/23, 1929 Peugeot 190S, 1986 Moss Monaco