need SQL code to extract hyperlink URL and clickable text from nvarchar field populated with html

I have a table of product descriptions (details) where most every record includes some html formatting and one or more hyperlinks.  I need to extract from these product descriptions a list of all the hyperlink URLs contained in all of the product description records in my table, and as a separate result set column, the clickable text associated with each hyperlink URL.

A good answer to this questions will be a SQL statement executable against SQL Server 2005 that generates a list of URLs of <a href> style hyperlinks contained in all the records of the product descriptions (details), and as a separate field in the result, the clickable text that activates each URL.  Note that some records in my table contain no html formatting and some records will contain one or more hyperlinks whose URL may be enclosed in single, <a href=' '>, or double <a href=" ">, quotes.

example table:

create table productTable
(
  details nvarchar(2650)
)
go
INSERT productTable VALUES ('<b>test product 1</b><br><i>example text</i>test<a href="http://www.domain.com/pc/Search?keyWord=test&type=1&">click here</a>example text: example text<h2>example text</h2>') 
INSERT productTable VALUES ('<b>test product 2</b><br><i>example text</i>test<a href=''/cp/pc/product?product=2''>click here</a>example text: example text<h2>example text</h2>')
INSERT productTable VALUES ('test product 3 (example text)<br><br><i>example text</i>test<br><a href='' domain.com/cp/pc/product?product=3''>click here</a>example text: example text<br><a href="product?product=2010">temp</a><h2>example text</h2>') 

INSERT productTable VALUES ('<b>test product 4 (example text)</b><br><br><i>example text</i>test<br>example text: example text<br><h2>example text</h2>')
INSERT productTable VALUES ('test product 4 (example text)<br><br><i>example text</i>test<br><a href=''/cp/product?product=2010''>temp</a>example text: example text<br><a href="domain.com/cp/pc/product?product=3">click here</a><h2>example text</h2>') 
 
go

Select all Open in new window

result set:

cp/product?product=2010                                                      example text
/cp/pc/product?product=2                                                     click here
domain.com/cp/pc/product?product=3                                           click here
http://www.domain.com/pc/Search?keyWord=test&type=1&                         click here
product?product=2010                                                         temp

Select all Open in new window

Thank You for considering my question.