@value = RTRIM(LTRIM(SUBSTRING(@listOfValues,1,CHARINDEX(@delimiter, @listOfValues,0)-1))), @listOfValues = RTRIM(LTRIM(SUBSTRING(@listOfValues, CHARINDEX(@delimiter ...
3. CHARINDEX - Index of the start of a substring in a string (Search start index can also be given to start searching from a specific position) 4. ‘+’ - Concat using + adds 2 strings together (Most ...