This simple table-valued function, when combined with an APPLY operator, allows you to identify nth position strings within a string that has separators.
2019-10-19
5 reads
STRING_SPLIT with Index as Table-Valued Function
CREATE FUNCTION [dbo].[tvfn_String_Split_with_Index] ( @String varchar(max), @Separator varchar(10) ) RETURNS @IndexedCharacters TABLE ( [Index]intNOT NULL, [Character]varchar(max)NULL ) AS BEGIN IF @String IS NULL INSERT INTO @IndexedCharacters SELECT 0 AS [Index], 'No value' AS [Character] ELSE INSERT INTO @IndexedCharacters SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS [Index], value AS [Character] FROM STRING_SPLIT(@String, @Separator) RETURN END
Related content
2019-11-01 (first published: 2019-10-19)
6,055 reads
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2020-06-23 (first published: 2009-03-25)
495 reads
The Basics of Cryptography Part 2
Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.
2005-08-17
10,925 reads
An Interview with Idera CEO, Rick Pleczko
I was talking with the people over at Idera a few weeks ago and they mentioned that their CEO would be happy to give us a few minutes of his time. So I took them up on the offer and built a list of questions about Idera and SQL Server 2005. Take a moment to learn about the vendor view of the world and the impending release of SQL Server 2005.
2005-03-15
6,067 reads