ORDER BY CAST(RIGHT(value, LEN(value) - 1) as int)
Select allOpen in new window
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
What you describe is typical of character sorting, so to sort numerically you can CAST(that number as numeric(19,4))
This also assumes that every value is a number, otherwise you'd have to weed them out.