I would do this
Select Upper(username) USERNM
>From users
Order By USERNM
If you want to maintain case you would have to do:
Select Upper(username) USERNM,
username USERNAME
>From users
Order By USERNM
Use the one field to sort and the other field that maintains case
Scott Rosenbaum
-----Original Message-----
From: Jim Murphy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 8:03 AM
To: 'Derby Discussion'
Subject: Question about UPPER/UCASE
Should this work, assuming a user table with the right shape?
select username from users order by upper(username)
I get syntax error @ "upper"
Regards,
Jim Murphy
Mindreef, Inc.
