If you want and don't mind slow code, you could leave it at that. Across a lot of rows, it's going to be slow (because of the WHILE LOOP...

Here is it:

ALTER FUNCTION [dbo].[Split]

(

@RowData nvarchar(max),

@Split1 nvarchar(1),

@Split2 nvarchar(1)

)

RETURNS @RtnValue TABLE

(

[Property] nvarchar(2000),

[Value] nvarchar(500)

)

AS

BEGIN

DECLARE @data nvarchar(max)

DECLARE @Property nvarchar(2000)

DECLARE @DataValue nvarchar(500)

WHILE (Charindex(@Split1,@RowData)>0)

BEGIN

--...

I made simple function that make what I wanted. The problem is that, I dont know how to do with a table like this,

ID Value

1 ...