I need to sort character strings (house numbers) which are digits (like
'123') or digits-letters (like '123A') . I need to sort them BY NUMBER, for
I cannot use
ORDER BY CONVERT(int, house_no), house_no
because CONVERT(int, house_no) returns an error when it encounters a letter
Does anybody have any idea?