Extract Host Name (Domain Name) from URL in SQL Server

SQL

CREATE TABLE #MyTable 
(
 Id int,
 Name varchar(20), 
 URl varchar(30)
);

INSERT INTO #MyTable (Id, Name, URL) VALUES(1,'abx' ,'google.com')
INSERT INTO #MyTable (Id, Name, URL) VALUES(1,'xyz' ,'yahoo.com')
INSERT INTO #MyTable (Id, Name, URL) VALUES (1,'pqr' ,'cricinfo.com')

SELECT  SUBSTRING( URL, 1, LEN(URL) -4 ) URL
FROM #MyTable

DROP TABLE #MyTable

Screenshot