I have a column that
is a varchar(6) I need to sort it by the rows that are integers 1st then the
character ones or vice versa, I just need the values that can be converted to
integer to sort by their numeric value.
i.e
1, 2, 3, 4, 5, 10,
11, A, B, C
instead
of
1, 10, 11, 2, 3, 4,
5, A, B, C
Any
suggestions?
