--------------------测试数据--------------------
xx-US-aa
xx-BB-KK-aa
--------------------SQL语句--------------------
SELECT
SUBSTRING(RIGHT(
字段名,
len(字段名)特殊符号CHARINDEX('特殊符号',字段名)),
0,CHARINDEX('特殊符号',RIGHT(字段名,
len(字段名)特殊符号CHARINDEX('特殊符号',字段名))))
--------------------执行语句--------------------
SELECT
SUBSTRING(
RIGHT(
'xx-US-aa',
len('xx-US-aa')-CHARINDEX('-','xx-US-aa')),
0,CHARINDEX('-',RIGHT('xx-US-aa',
len('xx-US-aa')-CHARINDEX('-','xx-US-aa'))))
返回US
SELECT
SUBSTRING(
RIGHT(
'xx-BB-KK-aa',
len('xx-BB-KK-aa')-CHARINDEX('-','xx-BB-KK-aa')),
0,CHARINDEX('-',RIGHT('xx-BB-KK-aa',
len('xx-BB-KK-aa')-CHARINDEX('-','xx-BB-KK-aa'))))
返回BB