Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

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.