TSQL Code to Find String Between Two String DECLARE @iIndex INTEGER = 17 DECLARE @Temp nvarchar(MAX)='1234,ABCDEFGHIJ,This Is,A,Test' SELECT CHARINDEX(',',@Temp,@iIndex) SELECT SUBSTRING(@Temp,@iIndex,CHARINDEX(',',@Temp,@iIndex)-@iIndex)