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