HELP: Different results on SQL sort, depending on the Tool?

Hi,
i've a problem with sorting a column, getting different results depending on the tool.

Environment:
Oracle 8.1.6, NT 4.0 (SP5)

The Query:
SELECT * FROM mytable ORDER BY mycolumn ASC

This is the result of a query by 'SQL Plus Worksheet': 0000000006
0000100100
A00000
A06015
A06016

This is the result of a query by 'Oracle ODBC 32Bit Test' : A00000
A06015
A06016
0000000006
0000100100

Why has the same SQL statement different results? How can this be solved?

Can anyone help me?
Regards Stefan Received on Tue Jul 11 2000 - 00:00:00 CDT