Using the article
I managed to do it
declare @t varchar(100), @o varchar(100), @c int
set @t = 'gdh-gj-90890-878.325-L-MP-ui'
set @c = 0
DECLARE @Str NVARCHAR(MAX)
SET @Str = '-' + @t + '-'
DECLARE @Part NVARCHAR(MAX)
DECLARE @IND INT
SET @IND = CHARINDEX('-',@Str)
DECLARE @EIND INT set @EIND = 0
WHILE(@IND != LEN(@STR))
BEGIN
SET @EIND = ISNULL(((CHARINDEX('-', @Str, @IND + 1)) - @IND - 1), 0)
set @c = @c + 1
IF @c = 6
SELECT @o = (SUBSTRING(@Str, (@IND + 1), @EIND))
SELECT @IND = ISNULL(CHARINDEX('-', @STR, @IND + 1), 0)
END
select @o