SQL - Strange behavior

Hi there,

I have very strange results with a table in which are "normal" Strings and Strings like 0001 included.

Well, I did the following:

Create table test (test_nr char(18))

Values:

Insert into test values ('ZUABSCHLAG')
Insert into test values ('0001')
Insert into test values ('0002')

1. Query

Select test_nr from test order by test_nr

Result:
ZUABSCHLAG
0001
0002

2. Query

Select test_nr from test where test_nr>'ZUABSCHLAG'

Result:
No rows

Thanx for any help,

Christian Hartmann Received on Thu Jun 15 2000 - 00:00:00 CDT