|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 13th, 2005, 03:54 AM
|
|||
|
|||
|
SQL ORDER BY Problem
I have the following data:
7500 9000 1000 10000 2000 3000 When I do an ORDER BY the data above is sorted as follows: 1000 10000 2000 3000 7500 9000 Does anyone know why this is happening? I need it to sort as follows: 1000 2000 3000 7500 9000 10000 Any help would be much appreciated.
|
|
#2
January 13th, 2005, 10:09 PM
|
||||
|
||||
|
If these are numeric fields, you can have an SQL statement like this:
SELECT * FROM YourTable ORDER BY YourAmountField ASC
|
|
| Viewing: ASP Free Forums > Database > SQL Development > SQL ORDER BY Problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
