CONCAT('<a href="', part.link, '"<', 'link', '></a>') AS 'Weblink'
generates a table line<td class="col8"><a href="http://www.alliedelec.com/search/searchresults.aspx?dsNav=Ntk:Primary|203STBW|3|,Ny:True,Ro:0&dsDimensionSearch=D:203STBW,Dxm:All,Dxp:3&SearchType=0"<link></a></td>
where the <, > characters appearing in as <, > so the link does not work.
Please let me know your suggestions.
Thanks.