• pls try below code.

    declare @t varchar(2000)='BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator]'

    select 'BUILTIN\ADMINISTRATORS: [System Admin]YES'+SUBSTRING(@t,PATINDEX('%Disk Admin]YES%',@t)-2,16)