Skip to main content
N
Newsgroup_User
Inspiring
January 20, 2007
Question

Orderby decimal as a number MS SQL

  • January 20, 2007
  • 2 replies
  • 246 views

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


This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

N
Newsgroup_UserAuthor
Inspiring
January 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
>
>
>
>
>


N
Newsgroup_UserAuthor
Inspiring
January 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





Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices