Alternative method using Lynn's fine test set (with the addition of a Beginninator 😀 )

😎

;WITH testdata AS (

SELECT

Directory

FROM

(VALUES

('/dev/Mywork/deailsbyWork'),

('/dev/MyTeam/deailsbyTeam'),

('/dev/MySubgroup/deailsbySubgroup'))dt(Directory)

)

,FIRST_CHOP AS

(

SELECT

TD.Directory

,SUBSTRING(TD.Directory,CHARINDEX(CHAR(47),TD.Directory,2) + 1,LEN(TD.Directory)) AS PART

FROM testdata TD

)

SELECT

FC.Directory

,SUBSTRING(FC.PART,1,CHARINDEX(CHAR(47),FC.PART,2) - 1) AS DIR_NAME

FROM FIRST_CHOP FC;

Output

Directory DIR_NAME

-------------------------------- ------------

/dev/Mywork/deailsbyWork Mywork

/dev/MyTeam/deailsbyTeam MyTeam

/dev/MySubgroup/deailsbySubgroup MySubgroup