MySQL ORDER BY not working for numbers
ORDER BY is not working properly for numbers,but it's working well if i give for columns containing alphanumeric or only characters. The code  which i had given is,

 dbResult = dbStatement.executeQuery("SELECT Bid_Number,Vendor_Name,Vendor_Address,Amount,Tax_Percentage,Amount_Aftertax,Expected_Deliverydate,Vendor_Code FROM purchase_bid    where PE_Number='"+PENumber+"' ORDER BY Amount_Aftertax ASC"); 

if in my table i've Amount_Aftertax column values as,
840.0
780.0
3180.0
3810.0
by giving this code,i'm getting result according to this order
3180.0
3810.0
780.0
840.0

Hoping a reply please...
Thanks in advance..


MySQL ORDER BY not working for numbers
===

ORDER BY is not working properly for numbers,but it's working well if i give for columns containing alphanumeric or only characters. The code  which i had given is,

 dbResult = dbStatement.executeQuery("SELECT Bid_Number,Vendor_Name,Vendor_Address,Amount,Tax_Percentage,Amount_Aftertax,Expected_Deliverydate,Vendor_Code FROM purchase_bid    where PE_Number='"+PENumber+"' ORDER BY Amount_Aftertax ASC"); 

if in my table i've Amount_Aftertax column values as,
840.0
780.0
3180.0
3810.0
by giving this code,i'm getting result according to this order
3180.0
3810.0
780.0
840.0

Hoping a reply please...
Thanks in advance..

