SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION f_crm_add
(
@str varchar(100),
@split varchar(1)
)
RETURNS
@table TABLE
(
col nvarchar(10)
)
AS
BEGIN
DECLARE @splitlen int
SET @splitlen=LEN(@split+'a')-2
WHILE CHARINDEX(@split,@str)>0
BEGIN
INSERT @table VALUES(LEFT(@str,CHARINDEX(@split,@str)-1))
SET @str=STUFF(@str,1,CHARINDEX(@split,@str)+@splitlen,'')
END
INSERT @table VALUES(@str)
RETURN
END
GO
select sum(cast(col as int)) from f_crm_add('12,14,15',',')
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION f_crm_add
(
@str varchar(100),
@split varchar(1)
)
RETURNS
@table TABLE
(
col nvarchar(10)
)
AS
BEGIN
DECLARE @splitlen int
SET @splitlen=LEN(@split+'a')-2
WHILE CHARINDEX(@split,@str)>0
BEGIN
INSERT @table VALUES(LEFT(@str,CHARINDEX(@split,@str)-1))
SET @str=STUFF(@str,1,CHARINDEX(@split,@str)+@splitlen,'')
END
INSERT @table VALUES(@str)
RETURN
END
GO
select sum(cast(col as int)) from f_crm_add('12,14,15',',')