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('_',CUSTOMER_TERRITORY,charindex('_',CUSTOMER_TERRITORY,1)+1)+1)
- charindex('_',CUSTOMER_TERRITORY,charindex('_',CUSTOMER_TERRITORY,1)+1)-1
) AS name3
結果:
--
計算位置到眼睛都流淚了……
--
太好用了這個::><::
回覆刪除乾蝦大大分享~~~