tsql字符串截取

declare @school nvarchar(max)
set @school=N'中国人民大学(苏州校区)（K53）'
select @school
,len(@school) [len]
,charindex('(',@school) [first indexof]
,len(@school)+1-charindex('(',reverse(@school)) [last indexof]
--,reverse(@school)
,substring(@school,len(@school)+1-charindex('(',reverse(@school))+1,len(@school)-(len(@school)+1-charindex('(',reverse(@school)))-1)
,replace(right(@school,len(@school)-(len(@school)+1-charindex('(',reverse(@school)))),')','')
,replace(reverse(substring(reverse(@school),1,charindex('(',reverse(@school)) - 1)),')','')