Splits the text according to each : character in the example:value:data variable. The result will be a table with 3 rows.

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