SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[Test_GetOrderTable] (@string varchar(max))

returns @tblOrder Table(id int identity(1,1),strings varchar(100))

AS

begin

declare @LocalVar varchar(100)

declare @pos int

set @pos=1

set @LocalVar=''

set @string = ltrim(rtrim(@string))

while (@pos <=len(@string))

begin

if (substring(@string, @pos,1)!=',')

begin

set @LocalVar =@LocalVar + substring(@string,@pos,1)

set @pos=@pos+1

end

else

begin

if @LocalVar <> ''

insert into @tblOrder values(ltrim(rtrim(@LocalVar)))

set @pos= @pos+ 1

set @LocalVar=''

end

end

if @LocalVar <> ''

insert into @tblOrder values(ltrim(rtrim(@LocalVar)))

return

end

GO

:-):-):-)

Select * from [dbo].[Test_GetOrderTable] ('1,2,8,6,4,23,74,94,4,0')