Advertisement
infogulch

Untitled

Aug 31st, 2011
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. IF OBJECT_ID('dbo.ufn_SplitGet',N'FN') IS NOT NULL DROP FUNCTION dbo.ufn_SplitGet;
  2. GO
  3.  
  4. CREATE FUNCTION dbo.ufn_SplitGet( @str nvarchar(max), @d nvarchar(5), @id int )
  5. RETURNS nvarchar(max)
  6. WITH SCHEMABINDING
  7. AS
  8. BEGIN
  9.     RETURN (SELECT TOP 1 item FROM dbo.ufn_Split(@str, @d) WHERE id = @id)
  10. END
  11. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement