How to sort alphanumeric string in SQL ?

How to sort alphanumeric string in SQL ?

Suppose we have a column with data in sql table below:

CT6
CT4
CT3
CT2
CT23
CT50
CT52
CT15
CT14
CT15
CT16


SELECT * FROM dbo.tbl_Data WHERE Status=1
ORDER BY 
LEFT(AlphaNumComun, PATINDEX('%[0-9]%', AlphaNumComun)-1) ASC,
CONVERT(INT, SUBSTRING(AlphaNumComun, PATINDEX('%[0-9]%', AlphaNumComun), LEN(AlphaNumComun))) ASC