order by case insensitive

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Sergio Gonzalez Thu, 12 Dec 2002 17:01

#11098

Author: Sergio Gonzalez
Date: Thu, 12 Dec 2002 17:01

10 lines
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.

Re: order by case insensitive

#11101

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads