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