Hi! I´m trying to sort upon a float column, but SQL is not doing it. Is there any restriction in sorting this type of data?
Jan 30, 2008, 6:33 AM
Veteran / Moderator (18441 posts)
Jan 30, 2008, 6:33 AM
Post #2 of 3
Views: 9350
Hi,
Wrong forum I've moved your post for you.
Regarding your question - from memory, the only way I've managed to sort FLOAT type numbers, is with a CHAR field, and then just do ORDER BY FieldName DESC.
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Wrong forum I've moved your post for you.
Regarding your question - from memory, the only way I've managed to sort FLOAT type numbers, is with a CHAR field, and then just do ORDER BY FieldName DESC.
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!