Gossamer Forum
Home : General : Databases and SQL :

order by float numbers

Quote Reply
order by float numbers
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?
Quote Reply
Re: [ACB] order by float numbers In reply to
Hi,

Wrong forum Wink 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!
Quote Reply
Re: [Andy] order by float numbers In reply to
Thanks! This is my first quotation.
I´ll try it that way.

Thanks again.