Home » Developer & Programmer » Forms » ORDER BY..... IN TLIST
ORDER BY..... IN TLIST [message #79605] Tue, 25 June 2002 14:10 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hello All,

My problem is that I have a search list form that is called from a form to do a search based on passed criteria. The list is populated with all of the names 'LIKE' the passed criteria. The thing is, even if I do an ORDER BY NAME in the where clause of the TLIST that is populated upon new form instance, everything goes in ALPHA order, but all CAPS names all show up in alpha order and then non capitalized after. Is there a way to get everything in alpha order, no matter if it's capitalized or not???

ie.
current situation...

(TLIST)
AAAAA
BBBBBB
EEEEE
ZZZZZ
aaaa
bbbb
eeeee
zzzzzz

I want...

(TLIST)
AAAAAA
aaaaaa
BBBBBB
bbbbbb
EEEEE
eeeee
ZZZZZ
zzzzz

Thanx,
Tyler

Report message to a moderator

Re: ORDER BY..... IN TLIST [message #79608 is a reply to message #79605] Tue, 25 June 2002 20:44 Go to previous message
Remash
Messages: 52
Registered: November 2000
Member
Hi

Try this....
ORDER BY UPPER(NAME)

Regards

Report message to a moderator

Previous Topic: Re: free material for oracle8i and developer 2000
Next Topic: simultaneous access of the same record from two different machines
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:28:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.