How to sort the alphanumeric column in sqlserver 2000?

you can sort the column by three way

SELECT std
FROM student_information ORDER BY
case when ISNUMERIC(std)<>1 then std else '0' end,
case when ISNUMERIC(std) =1 then CONVERT(INT, std) else -1 end

(or)

select std from student_information order by right(replicate(N' ',50)+std,50)

(or)

select std
from tt_staff where hand='EMP07121'
ORDER BY CASE WHEN IsNumeric(std)=1 THEN '' ELSE std END,
CASE WHEN IsNumeric(std)=0 THEN 0.00 ELSE Cast(std as Decimal(15,2)) END