The ColdFusion server allows embedded SQL in the templates, and it allows
exactly that same functionality against any database it supports (ODBC,
OLEDB, and several native drivers).

In fact, I have used pretty much the exact same logic as the first
example...

Jared

-----Original Message-----
From: Paul Gallagher [mailto:paul@...]
Sent: Wednesday, August 02, 2000 4:28 PM
To: IB-Architect@egroups.com
Subject: Re: [IB-Architect] Re: Creating a case-insensitive collation
set

----- Original Message -----
From: David Schnepper <dave@...>
To: <IB-Architect@egroups.com>
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) ??
>
> Dave
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

ABC
abd
BCB
CBB
the latter would return
ABC
BCB
CBB
abd

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?

Paul




To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com