Am using sqlserver2008.
I have a table t1 with columns A and B with data like column A having value 1 and column b
having value like the data which I attached here.
I would like to extract the data from this like starting with "http" and ending with "plv"
ie I would like to fetch the data from t1 like below
In the attached file these two lines are there. Like this i have many columns from every column of "B" I need to fetch like this. It can be any number of links(data like this). That many times column A will repeat. Column "B" will be having data continuously. for clarity I gave space before "http" and after "plv" in the data attached.