Orderby decimal as a number MS SQL

Report · Jan 20, 2007

http://www.financeextra.net/creditcards/LowAPR.asp

OK - it should be listing them in numerical order (which it kinda is)
however it doesn't seem to be treating them as a decimal ...

The SQL looks like SELECT * FROM dbo.CreditcardDetails ORDER BY Rate DESC"

Anyone got any advice ?

Cheers Gerry

http://www.FinanceExtra.net

Report · Jan 20, 2007

Try

SELECT * FROM dbo.CreditcardDetails ORDER BY cast(Rate as float) DESC

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Jan 21, 2007

Cheers for that ...

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:eou7sf$gjd$1@forums.macromedia.com...
> Try
>
> SELECT * FROM dbo.CreditcardDetails ORDER BY cast(Rate as float) DESC
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>
>