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
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