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