Similarly, if I order by last name, last names consisting of two or more
words (e.g., "van Agoden") fall at the end of the list, after last names
beginning with zed. I would expect
Val, JB
Van, ER
Vanel, SV
Van Agoden, BT
or some similar ordering, but not
Val, JB
Van, ER
Vanel, SV
...
Zag, SH
Zuli, TP
Van Agoden, BT
etc.
I'm using version 6.5.3.
James Eric Lawson
Research Publications Editor III
National Simulation Resource
eric@bioeng.washington.edu
On Fri, 7 Jul 2000, Patrick Coulombe wrote:
> hi,
> if I do a query like this one :
>
> SELECT name from medias ORDER BY name
>
> name
> ----
> AAAA
> CCCC
> EEEE
> VVVV
> ZZZZ
> ÉCCC
> ----
> 6 rows
>
>
> Why the record : ÉCCC is at the end?
> HOW can I fix this?
>
> Thank you
> Patrick
>