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

Sep 3 '08 #1

Sgt.Sausage

"Chico Che" <js*****@yahoo.comwrote in message
news:Xn**********************@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'.

Sep 5 '08 #2