At 11:56 PM 12/26/2001 +0000, jwcanada wrote:

>> One is a set of special operators that are explicitly
> > case insensitive. That's really non-standard, but it's
> > very clean, architecturally.
>
>This is ideal as MS SQL Server has such settings. Its default is
>caseInSensitive.

I think you misunderstood me. What I meant was that we would
have special operators (e.g. ~= meaning equal ignoring case, or
~> meaning greater than ignoring case). Frankly, I find setting
the whole database to case insensitive or sensitive to be a bad
idea ... sooner or later you're going to need to compare data
between databases... and some character data is inherently case
sensitive (e.g. passwords).


Regards,

Ann
www.ibphoenix.com
We have answers.