SELECT DISTINCT CUSTOMER_TERRITORY AS CustomerFullName , charindex ( '_' , CUSTOMER_TERRITORY , 1 ) as CharIndex , charindex ( '_' , CUSTOMER_TERRITORY , 1 )+ 1 as bb , charindex ( '_' , CUSTOMER_TERRITORY , charindex ( '_' , CUSTOMER_TERRITORY , 1 )+ 1 )- charindex ( '_' , CUSTOMER_TERRITORY , 1 )- 1 as cc , SUBSTRING ( CUSTOMER_TERRITORY , 1 , charindex ( '_' , CUSTOMER_TERRITORY , 1 )- 1 ) AS name1 , SUBSTRING ( CUSTOMER_TERRITORY , charindex ( '_' , CUSTOMER_TERRITORY , 1 )+ 1 , charindex ( '_' , CUSTOMER_TERRITORY , charindex ( '_' , CUSTOMER_TERRITORY , 1 )+ 1 ) - charindex ( '_' , CUSTOMER_TERRITORY , 1 )- 1 ) AS name2 , SUBSTRING ( CUSTOMER_TERRITORY , charindex ( '_' , CUSTOMER_TERRITORY , charindex ( '_' , CUSTOMER_TERRITORY , 1 )+ 1 )+ 1 , charindex ( '_' , CUSTOMER_TERRITORY , charindex ( '_' , CUSTOM...