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,
How does one do a case-insensitive search using sql
methods when the underlying database is case-sensitive? Although I can
force the search on the database to look for a lower case string, I
cant make the person giving the value give me the value in lower case,
and I know I shouldnt use
I wrote:
How does one do a case-insensitive search using sql
methods when the underlying database is case-sensitive? Although I can
force the search on the database to look for a lower case string, I
cant make the person giving the value give me the value in lower case,
and I know I shouldnt
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
