How do I change sort order when all numeric values are in a text field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Mad Ape - 04 Feb 2008 15:12 GMT

I have this SQL:

Select ta_point from tblTally Group By ta_point

which gives:

1
10
2
21

etc

All values are numeric but it is a NVARCHAR field.

I tried:

Select ta_point from tblTally Group By ta_point Order By ta_point
which does not change results

Select convert(float, ta_point) from tblTally Group By ta_point Order
By ta_point which does not work

How do I do this to get:

1
2
10
21

Thanks

Mad Ape

Reply to this Message

ErikEJ - 04 Feb 2008 16:59 GMT

How about something like this:

SELECT CONVERT(float, ta_point) AS SortPoint from tblTally ORDER BY
SortPoint

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

>I have this SQL:
>
[quoted text clipped - 29 lines]
>
> Mad Ape

Reply to this Message

The Mad Ape - 04 Feb 2008 17:48 GMT

> How about something like this:
>
[quoted text clipped - 3 lines]
> Erik Ejlskov Jensen, Mobile App Dev MCTS
> Check out my SQL Compact blog athttp://erikej.blogspot.com

It works great.

Thanks.

The Mad Ape
www.tatumba.com

Reply to this Message