order by question

Hi,

i have a order by question. I have a table x with one column t char(5). The table contain 6 rows.

#1

1)
#2

2)
#3

3)

I like sort table (select t from x order by t), but receive no order. I like follow sorting:

#1
#2
#3

1)
2)
3)

Can anybody help me?

Sorry for my language. :-)

Frank Streitzig
Germany Received on Mon Dec 13 1999 - 02:13:31 CST