SQL SERVER 字符串分割用substring

 

declare @InpS nvarchar(max)='ACP,LeasingIndividualUsedCarNonCertified'
select @InpS,len(@InpS),charindex(',',@InpS),substring(@InpS,charindex(',',@InpS)+1,len(@InpS))