|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Sorting Strings
Lets say I have the following strings in my database (I can use use mysql/or ms access, whicher would make this easier)
2-10 5-1 5-110 3-FC797 10-FC797S 52-FCDEMO800 How would I order these from left to right in alpha-numerical order? Should I convert the field to something else? Right now its text. I want my query to sort like this: 2-10 3-FC797 5-1 5-110 10-FC797S 52-FCDEMO800 Thanks for help! |
|
#2
|
|||
|
|||
|
You will not get that using ORDER BY DESC or ASC because 1 and values with one will always bee before two in ASC and after two in DESC. You could create your own hash key and order by that.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Sorting Strings |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|