Subject | order by upper |
---|---|
Author | Benny Setiawan Tanua |
Post date | 2002-05-21T03:17:03Z |
Dear All,
I've got a problem with my query
" SELECT ID, UNICODE_FIELD FROM LANGUAGE ORDER BY UNICODE_FIELD " == > it's
ok
" SELECT ID, UNICODE_FIELD FROM LANGUAGE ORDER BY UPPER(UNICODE_FIELD) " ==
indef of :
ABC
abc
DEF
def
not like :
ABC
DEF
abc
def
does anyone knows the query ..??
Thanks,
Benny Setiawan T
I've got a problem with my query
" SELECT ID, UNICODE_FIELD FROM LANGUAGE ORDER BY UNICODE_FIELD " == > it's
ok
" SELECT ID, UNICODE_FIELD FROM LANGUAGE ORDER BY UPPER(UNICODE_FIELD) " ==
> errormy guess is that indexes by unicode_field
indef of :
ABC
abc
DEF
def
not like :
ABC
DEF
abc
def
does anyone knows the query ..??
Thanks,
Benny Setiawan T