467,917 Members | 1,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Sorting

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
  • viewed: 1269
Share:
1 Reply

"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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by dont bother | last post: by
7 posts views Thread by Federico G. Babelis | last post: by
19 posts views Thread by Owen T. Soroke | last post: by
4 posts views Thread by Ambica Jain | last post: by
7 posts views Thread by Kamal | last post: by
5 posts views Thread by lemlimlee | last post: by
5 posts views Thread by jrod11 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.