Subject | UPPER() in ORDER BY |
---|---|
Author | Jason Wharton |
Post date | 2000-12-05T23:26:30Z |
Is it possible to allow the use of the UPPER( ) function in the order by
clause for case insensitive sorts? I noticed that right now this is not
possible but it sure would solve some problems for me if we could.
For now I use a mirror/surrogate column that is trigger maintained to be the
UPPER( ) equivalent but it is a pain to have to do that even though IBO
abstracts it all into a very simple setting...
What are the internal ramifications of introducing such a capability?
Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
clause for case insensitive sorts? I noticed that right now this is not
possible but it sure would solve some problems for me if we could.
For now I use a mirror/surrogate column that is trigger maintained to be the
UPPER( ) equivalent but it is a pain to have to do that even though IBO
abstracts it all into a very simple setting...
What are the internal ramifications of introducing such a capability?
Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com