Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION splitString( @stringToSplit VARCHAR(MAX) )
- RETURNS
- @returnList TABLE ([Name] [nvarchar] (500))
- AS
- BEGIN
- DECLARE @name NVARCHAR(255)
- DECLARE @pos INT
- WHILE CHARINDEX('|', @stringToSplit) > 0
- BEGIN
- SELECT @pos = CHARINDEX('|', @stringToSplit)
- SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)
- INSERT INTO @returnList
- SELECT @name
- SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
- END
- INSERT INTO @returnList
- SELECT @stringToSplit
- RETURN
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement