Is there any way to turn off case sensitivity in DB2 UDB 8.1.4 for Windows?

The following queries will return different results -

Select * from table where column = 'A'

Select * from table where column = 'a'


I'd like to make it possible to get the same results from both queries
without having to use functions like UCASE or LCASE.

Thanks

==============================
Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706

631-665-8100 Voice
631-969-5988 Fax

http://www.computeryltd.com

DB2 & UDB email list listserv db2-l LazyDBA home page