Re: [IB-Architect] Re: Creating a case-insensitive collation set
----- Original Message -----
From: David Schnepper <dave@...>
Sent: Wednesday, August 02, 2000 12:19 PM
Subject: [IB-Architect] Re: Creating a case-insensitive collation set
> How would
> SELECT NOCASE(x) ...
> be different from
> SELECT UPPER(x) or LOWER(x) ??
In that example it is probably the same. But an ORDER BY is different.
SELECT ITEM FROM TABLE1 ORDER BY ITEM NOCASE
is not the same as
SELECT UPPER(ITEM) AS FIELD1 FROM TABLE1 ORDER BY FIELD1
the former returns
the latter would return
There are workarounds to this issue, but "true native"case insensitive
sorting would be more efficient than placing an UPPER(FIELD) in the query.
BTW, does anyone know if other DB's such as Oracle have this feature?