Posted by SQL on 09/26/05 18:07

Take a look at this
Run it in Query Analyzer

-- not ordered as int
select '1'
union all
select '2'
union all
select '11'
order by 1
-- ordered as int
select convert(int,1)
union all
select convert(int,2)
union all
select convert(int,11)
order by 1

--http://sqlservercode.blogspot.com/

[Back to original message]