The way to do it in SQL :
SELECT SUBSTRING( string , LEN(string) - CHARINDEX("https://stackoverflow.com/",REVERSE(string)) + 2 , LEN(string) ) FROM SAMPLE;
JSFiddle here http://sqlfiddle.com/#!3/41ead/11
The way to do it in SQL :
SELECT SUBSTRING( string , LEN(string) - CHARINDEX("https://stackoverflow.com/",REVERSE(string)) + 2 , LEN(string) ) FROM SAMPLE;
JSFiddle here http://sqlfiddle.com/#!3/41ead/11