Is it possible to order by a substring in a returned field?<BR>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 ...
So I've got this temp table in a stored procedure. Set @i = 1 While @i <= 10 Begin If (IsNumeric(Substring((Select SCNumberParsed From #Results), @i, 1))) = 1 Update ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results