I agree with everyone else that doing this in SQL should be avoided if at all possible. I could certainly come up with a hacky way of doing it, but it would be less than pleasant to read and, more ...

The LIKE condition selects rows by comparing character strings with a pattern-matching specification. It resolves to true and displays the matched string(s) if the left operand matches the pattern ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.