create table Tbl(
Pos varchar(32),
Name varchar(32),
Event varchar(32)
);
insert into Tbl values
('7', 'Grey', 'Javelin'),
('8', 'Hill', 'Javelin'),
('9', 'Jones', 'Javelin'),
('C', 'Norris', 'Javelin'),
('1', 'Adams', 'Javelin'),
('10', 'Kirk', 'Javelin'),
('11', 'Lewis', 'Javelin'),
('12', 'Moore', 'Javelin'),
('2', 'Bevan', 'Javelin'),
('3', 'Cain', 'Javelin'),
('4', 'Douglas', 'Javelin'),
('5', 'Evans', 'Javelin'),
('6', 'Fell', 'Javelin'),
('C', 'Owens', 'Javelin'),
('D', 'Pick', 'Javelin'),
('F', 'Quill', 'Javelin');
select * from Tbl order by ISNUMERIC(Pos) DESC, TRY_CAST(Pos AS INT);
Telegram: DB developers channel