Wednesday, 7 December 2016

Order by Alphanumeric


ORDER BY
CAST(LEFT(t.ComponentName,PATINDEX('%[^0-9]%',t.ComponentName)-1) AS INT)

No comments:

Post a Comment