@Vipin, there are spaces between the dashes, thus I've removed them.

Simple Query:

CREATE TABLE #TBL_DASHES

(

DH_ID INT IDENTITY(1,1) NOT NULL

,DH_STRING VARCHAR(200) NOT NULL

);

INSERT INTO #TBL_DASHES (DH_STRING)

VALUES

('ABL¯ABL¯0¯0¯ABL¯¯¯¯¯¯¯¯¯')

,('ABL¯ABQ¯480¯825¯DLS¯AMA¯ABQ¯¯¯¯¯¯¯')

,('ABL¯ACD¯808¯1255¯DLS¯ELP¯TCS¯PHX¯ACD¯¯¯¯¯')

,('ABL¯ADE¯1256¯471¯DLS¯AMA¯ABQ¯LSV¯ADE¯¯¯¯¯')

,('ABL¯AFT¯1140¯1744¯DLS¯LAX¯FON¯AFT¯¯¯¯¯¯')

,('ABL¯AHM¯1178¯1637¯DLS¯LAX¯AHM¯¯¯¯¯¯¯')

,('ABL¯ALB¯1769¯1825¯DLS¯WIL¯ALB¯¯¯¯¯¯¯')

,('ABL¯ALE¯1041¯1150¯DLS¯ALE¯¯¯¯¯¯¯¯¯')

;

select

DH_ID,

DH_STRING, len(DH_STRING) AS DH_STRING_COUNT,

REPLACE(DH_STRING, '¯', '') AS DH_STRING_NO_DASH, len(REPLACE(DH_STRING, '¯', '')) AS DH_STRING_NO_DASH_COUNT,

len(DH_STRING) - len(REPLACE(DH_STRING, '¯', '')) AS DASHES_COUNT

from #TBL_DASHES