SQL Server string cutting function _mssql

Copy code code as follows:

CREATE FUNCTION Fgetstrbysplit
(
@Source VARCHAR (max),
@Index INT,
@SplitChar VARCHAR (1)
)
RETURNS varchar (MAX)
As
BEGIN

DECLARE @Len INT
DECLARE @n INT = 0
DECLARE @ChIndex INT
DECLARE @Result VARCHAR (MAX)
--Get total length
SET @Len = Len (@Source)
--Get the cut character position
SET @ChIndex = CHARINDEX (@SplitChar, @Source)

While @ChIndex > 0
BEGIN
IF (@n = @Index)
BEGIN
SET @Source = SUBSTRING (@Source, 0, @ChIndex)
Break
End

SET @Source = SUBSTRING (@Source, @ChIndex +1, @Len)
SET @ChIndex = CHARINDEX (@SplitChar, @Source)

SET @Len = Len (@Source)
SET @n = @n + 1

End

Return @Source
End
Go

--Call
DECLARE @value VARCHAR (max)
SET @value = dbo.fgetstrbysplit (' 645002*01_45854_183677_12 ', 0, ' _ ')
PRINT @value

Results:
645002*01
--1

45854

--2

183677