17 Jan
2001
17 Jan
'01
9:13 p.m.
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