Sql Server中排序减号"-"的问题

select distinct v.lngDepartMentID,strDepartmentName,strDepartmentLevelCode code ,case when g.lngDepartmentID>0 then 1 else 0 end blnCheck
        from dbo.view_Department_Effective v left join (select * from Gm_AccountDepartment where lngShopID =1031) g 
                        on g.lngDepartmentID =v.lngDepartmentID
        order by strDepartmentLevelCode

有"-"号的地方,排序往往会忽略.

SELECT * FROM view_Department_Effective   
WHERE  strDepartmentLevelCode LIKE 'B.BNR000.ESH200.ESH200%'
 order by strDepartmentLevelCode
 
改成 replace(strDepartmentLevelCode ,'-','_') ,如果贸然去改排序规则,可能会发送莫名其妙的报错