Query - Sort Alpha as Numeric 1

[RoguePoet01]

Hi,

I have a table with Silo numbers listed in them, but they're listed as alpha, not numeric.

So when I do a sort, I get:

1
10
11
2
3
4
...

Instead of:

1
2
3
4
...
10
11

Is there any way around this?

Thanks.

 

[Pattycake245]

One thing I did to ensure these are in "numeric" order is cast the values as ints when ordering:

select field1 from table order by cast(field1 as int)

There may be a more elegant way out there though.

Tim

 

[RoguePoet01]

That's a big help. I found something similar.

Select * from Table Order by CONVERT(Int, Silo)

Thanks for your help.