hi

in my table, i have a column with nvachar(20) but enter numeric value to it (1,2,3, ...).

my problem is that when i select from my table and sort with that column, it it does not sort correctly, it sorted like this :

Field1 Field2 Field3(nvarchar(20))
--------------------------------------
a1 b1 1
a2 b2 10
a3 b3 11
a4 b4 12

...

how to solve my problem and correct this problem ?

i want this result :

Field1 Field2 Field3(nvarchar(20))
--------------------------------------
a1 b1 1
a2 b2 2
a3 b3 3
a4 b4 4
...

thanks