select * from (select top 30 * from myTable order by [id] desc) t order by convert(int,tNum) desc 

select * from (select top 30 * from myTable order by [id] desc) a order by convert(int,tNum) desc 

select * from (select top 30 * from myTable order by [id]) t order by cast(tNum as int) desc