I am trying to execute following query having "order by lower (user_name) "
clause.
select * from user where user_name = 'zzzz' order by lower(user_name)
lower function works well in where clause as in :
select * from user where lower(user_name) = 'zzzz' order by user_name
Is it that lower is not supported in "order by" clause?
-alok
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|