acanalesg acanalesg
klimaye
/ itemAtIndexInASplitString
Created
December 27, 2013 13:56
sql scaler function to return an item at a specific index in a split string. Was useful to me in a select clause parsing a value like Age_0_14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE FUNCTION dbo.itemAtIndexInASplitString( @stringToSplit VARCHAR(MAX), @delimiter VARCHAR(5), @indexToReturn int) | |
| RETURNS | |
| varchar(max) | |
| AS | |
| BEGIN | |
| DECLARE @returnList TABLE ([ID] int, [Name] [nvarchar] (500)) | |
| DECLARE @name NVARCHAR(255) | |
| DECLARE @pos INT | |
| DECLARE @index INT | |
| DECLARE @return_value varchar(max) |