Article View: borland.public.interbase.sql
Article #11098order by case insensitive
From: Sergio Gonzalez
Date: Thu, 12 Dec 2002 17:01
Date: Thu, 12 Dec 2002 17:01
10 lines
1392 bytes
1392 bytes
Hello, 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! Sergio.
Technical Details
Message-ID:
<3df8c17e@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!newsfeed.frii.net!newsfeed.frii.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,af786547c04bc3d4,start X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-12 09:14:21 PST Reply-To: "Sergio Gonzalez" <shg@sion.com> From: "Sergio Gonzalez" <shg@sion.com> Newsgroups: borland.public.interbase.sql Subject: order by case insensitive Date: Thu, 12 Dec 2002 14:01:32 -0300 Lines: 13 Organization: SG X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 200.69.38.194 Message-ID: <3df8c17e@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039712638 200.69.38.194 (12 Dec 2002 09:03:58 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!newsfeed.frii.net!newsfeed.frii.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail