convert string to int

in my query can I convert a string to int

select convert(int,str_col) from table

I just need the order by, if there's a different way.

select str_col from table order by convert(int,str_col) Received on Tue Jun 22 2004 - 12:34:30 CDT