@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 ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...