Unfortunately there is no exactly the same functionality among built-in stored procedures / functions in SQL Server. However you could easily reproduce required behavior in your own UDF:


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fnTokens]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[fnTokens]
GO
create function fnTokens (@InputString as nvarchar(4000), @Delimiters as varchar(100))
returns @Tokens table (id int identity (1, 1) NOT NULL primary key clustered, Token nvarchar(4000))
as begin
declare @c as nvarchar(1), @Token as nvarchar(4000)
declare @i as int
set @Delimiters = @Delimiters + char(1)
set @InputString = @InputString + right(@Delimiters, 1)
select @i = 1, @Token = ''
while @i <= len(@InputString) begin
set @c = substring(@InputString, @i, 1)
if charindex(@c, @Delimiters) = 0
set @Token = @Token + @c
else
if @Token > '' begin
insert @Tokens (Token) values (@Token)
set @Token = ''
end
set @i = @i + 1
end
return
end
go