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 ...

In-Depth. Exploiting SQL Server 2008 Through Code. SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.