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

I was thinking I could look at sys.objects and sys.columns to get a list of tables and names and then use a cursor to loop through it all.