Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF OBJECT_ID('dbo.ufn_SplitGet',N'FN') IS NOT NULL DROP FUNCTION dbo.ufn_SplitGet;
- GO
- CREATE FUNCTION dbo.ufn_SplitGet( @str nvarchar(max), @d nvarchar(5), @id int )
- RETURNS nvarchar(max)
- WITH SCHEMABINDING
- AS
- BEGIN
- RETURN (SELECT TOP 1 item FROM dbo.ufn_Split(@str, @d) WHERE id = @id)
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement