Hi, I have a column defined as SORTNAME VARCHAR(70) Rows contain these Values: "LUTZ, JOSEF" "LUTZ, JOSEF ANTON" "LUTZ, JOSEFA"
When I do: SELECT * from table ORDER BY SORTNAME I get this order: "LUTZ, JOSEF" "LUTZ, JOSEFA" "LUTZ, JOSEF ANTON" I would expect "JOSEF ANTON" being before "JOSEFA". What is going wrong? Note: changing the definition to CHARACTER(70) does not change the behaviour. Thanks for your help. Helmut Leninger -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/054b8e96-ea3b-4495-915a-987143bf74efn%40googlegroups.com.
