Remove Delimiter And Get Strings in Separate Columns :
CREATE
FUNCTION FN_SeparateDelimeterFromString
(@string
NVARCHAR(MAX),@separator
NCHAR(1))
RETURNS
@SeparatedStrings TABLE
(string NVARCHAR(MAX))
AS
BEGIN
DECLARE @position int
SET @position =
1
SET @string =
@string + @separator
WHILE charindex(@separator,@string,@position)
<> 0
BEGIN
INSERT into @SeparatedStrings
SELECT substring(@string,
@position, charindex(@separator,@string,@position)
- @position)
SET @position =
charindex(@separator,@string,@position)
+ 1
END
RETURN
END
Declare
@Strings varchar(max)
Set
@Strings='1,2,3,4,5,6,7'
select
string from FN_SeparateDelimeterFromString(@Strings,',')
select
string from FN_SeparateDelimeterFromString('N,I,T,I,S,H,,K,U,M,A,R',',')