declare @url as varchar(200) set @url = 'https://something.xy/folder1/folder2/folder3' select SUBSTRING(@url, CHARINDEX('//', @url) + 2, CHARINDEX('/', @url, CHARINDEX('//', @url) + 2) - CHARINDEX('//', @url) - 2)