This is an interesting little problem. There are a few different ways you could go about doing it. Since the URLs are delimited by '/', you could probably write something...

Well you could do separate queries for ones starting with src= and href= since those add on characters. then as long as the count of characters is the same for...

You don't explicitly have to declare a @params variable in this particular example, but it's probably a good idea. Your code could be modified slightly

...

Thanks for the response Geoff. To your initial question about the nulls, part of the reason for wanting to make the returns null was that if say, stock A trades...