I want sort the below Alphanumeric Column in SQL Server.
SP-SS-2 SP-FAB-8 WD-1 WD-4A WD-11 WD-10 WD-2 WD-20
I want sorted by ascending order Output is as follows:
SP-FAB-8 SP-SS-2 WD-1 WD-2 WD-4A WD-10 WD-11 WD-20
Any tricks to make it sort properly?