Sorting

[Chico Che]

I have a table that has a column varchar which contains numeric and
alphanumeric values:

Examples

1
10
11
29A
2000
3
4
400
401
401A
402
404A
404B
5

Is there a way to sort correctly?

TIA

[Sgt.Sausage]

Re: Sorting


"Chico Che" <jsisk24@yahoo. comwrote in message
news:Xns9B0E7D2 29A415Chicoche@ 216.196.97.131. ..

>I have a table that has a column varchar which contains numeric and
alphanumeric values:
>
Examples
>
1
10
11
29A
2000
3
4
400
401
401A
402
404A
404B
5
>
Is there a way to sort correctly?

It *is* sorted 'correctly'.