SQL Statement sorting nvarchar - by user342957 STD-00-1 STD-00-2 STD-00-10 STD-00-1(T) STD-00-2(T) STD-00-10(T) STD-05-1 STD-05-2 STD-05-10 STD-05-1(T) STD-05-2(T) STD-05-10(T) WIP-00-1 WIP-00-1(T) What is the best way to achieve this? Read the article