db column types and sorting
|
Is there a work-a-round?for sorting numeric?data? That is to say. It looks to?me like numbers in a column is getting?sorted as if they were alpha characters i.e.? 110, 128, 141, 21, 25, 40....when it should be 21,25,40,110,128,141. I'd think a column type of numeric would resolve it, but I don't see that option.
TIA Lew? |
|
If you make all numbers the same length and pad them with prefix zeroes where needed, they sort correctly. You might suggest the numeric type addition on the beta group.
Duane -- Help: /static/help GMF's Wiki: /g/GroupManagersForum/wiki Search button at the top of Messages list A few site FAQs: /static/pricing#frequently-asked-questions |
¿ªÔÆÌåÓýUse zeros in your numbering system. 021,025,040,110,128,141. ? Don ? From: [email protected] <[email protected]> On Behalf Of Lew Volk ? Is there a work-a-round?for sorting numeric?data? That is to say. It looks to?me like numbers in a column is getting?sorted as if they were alpha characters i.e.? 110, 128, 141, 21, 25, 40....when it should be 21,25,40,110,128,141. I'd think a column type of numeric would resolve it, but I don't see that option. |
Lew Volk
Duane
Don Grass