UPPER()/ORDER BY question

[Ruslan Zasukhin]

On 4/21/06 5:40 AM, "Matthew Bargar" <matthew at sixredmarbles.com> wrote:

Hi Matthew!

> Hi all!  First question for the list, hope it's an easy one...

> I am trying to do a select query where the results are returned sorted by a
> string field.  The catch I am having is that by default Valentina ORDER BY is
> sorting using case-sensitivity... i.e., first I get the A-Z results and then
> the a-z results.  I'd really like to get my results ordered without
> case-sensitivity.  I tried multiple permutations on this:
>  
> SELECT * from users ORDER BY UPPER(user_last_name)

Currently you can get correct result using Table Method.
Define new Method (calculated filed) and use it in ORDER BY.
  
> in Valentina Studio but I kept getting either error 603 or 604 (field not
> found/syntax error).  Is there another approach I should be taking?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]