Sort problem

Hi all,
when sorting a table by a field which contains strings like "abc-1" and "abc_1 the sorting doesn't work correctly, that is the strings are mixed. Seems as if Oracle doesn't distinguish between _ and - How can I get the db to sort the table correctly ? Oracle Server is 7.3.4, character set is WE8ISO8859P1. Thanks in advance...

Regine Received on Tue Mar 26 2002 - 03:31:29 CST