First Sort Numbers and then Alphabet Characters in SQL Query result

when dealing with more than one digit , its not working. single digit fine that s when it comes lik

23

23-1

33333

3333-1

it is not working.

anyway i solved that issue.

the below query i used. it works fine..

Select *
from #sample order by
case
when isnull([Ticket Number], '' ) ='' then '-1'
when ISNUMERIC([Ticket Number]) =1 then convert(int, [Ticket Number])
when ISNUMERIC(replace([Ticket Number], '-', '')) = 1
then convert(int, substring([Ticket Number], 1, CHARINDEX('-',[Ticket Number])-1)) + (convert(int, (substring([Ticket Number], CHARINDEX('-',[Ticket Number])+1, LEN([Ticket Number])))) * 0.1)
else 9999999999
end