Re: order by case insensitive

Article View: borland.public.interbase.sql

Article #11101

Back to borland.public.interbase.sql Previous Next

#11101

From: Craig Stuntz TeamB
Date: Thu, 12 Dec 2002 17:17

26 lines
1565 bytes

In article <3df8c17e@newsgroups.borland.com>, shg@sion.com says...
> Can I specify an ORDER BY statement case insensitive?
> 
> Something like:
> 
> SELECT * FROM ITEMS ORDER BY UPPERCASE( ITEM_NAME )
> (this doesn't work)
> 
> Thanks in advance! You guys are the best!
> 
SELECT
  UPPER(ITEM_NAME), *
FROM
  ITEMS
ORDER BY
  1

	HTH,

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.18628ec47a11c1f298a3c2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3df8c17e@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,af786547c04bc3d4
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-12 09:24:05 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: order by case insensitive
Date: Thu, 12 Dec 2002 12:17:49 -0500
Message-ID: <MPG.18628ec47a11c1f298a3c2@newsgroups.borland.com>
References: <3df8c17e@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1039713478 65.86.87.242 (12 Dec 2002 09:17:58 -0800)
Lines: 26
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message