子串，& 

39;用于HTML标记。请查看以下链接以获取选项：

如何在sql语句where子句中使用Char（39）？ [ ^ ]

I am having the datas as CCD-1,CCD-20,CCD-23 etc. I want to sort them.
I tried the below query but it's not working
select * from X order by RIGHT(TA.CBFieldName,LEN(TA.CBFieldName)-CHARINDEX('-',TA.CBFieldName))

The substring, &

39; is for HTML markup. Please check the link below for options:

How do I use Char(39) in a sql statement where clause?[^]