Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2001-11-05 : 05:05:05
|
| Posted a similar question last week (thanks for the replys) but things move on....I have a varchar field, it containsJ99, J999, J1000, Jane, Jonathan ...I want to order this so that the data comes out in that order, BUT currently it comes out in the following orderJ1000, J99, J999, Jane, JonathanHow do I get it to order correctly <sob>? |
|
|
|
|
|
ORDER BY ala dictionary