This function searches for one character expression inside a second character expression, returning the starting position of the first expression if found. :::image ...

@value = RTRIM(LTRIM(SUBSTRING(@listOfValues,1,CHARINDEX(@delimiter, @listOfValues,0)-1))), @listOfValues = RTRIM(LTRIM(SUBSTRING(@listOfValues, CHARINDEX(@delimiter ...

Function accepts two parameters first the concatenated string and second the delimiter character. CREATE FUNCTION [dbo].[Split](@String nvarchar(4000),@Delimiter char(1)) RETURNS @Results TABLE (Items ...