> Is there a way to make the db2 database CASE
> INSENSITIVE so that a string like "Evaluation" would
select blah from table where translate(name)='SMITH'
note that this imposes overhead; just like any other 'case insensitive'
method. If worried about performance, you may want to store an uppercase
version of that field into your table as well.. Search it based on the
uppercase fieldname, display the mixed case version. That's what I do
with my web crawler.
-turgut
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
