how to write select query for merging two columns?

Dialect: MS SQL
guyhfghfghfh

Dialect: SQL 92
<a href="http://wgpatg.freehost.net.au/?">VMware Workstation 6.5</a>
VMware Workstation 6.5
<a href="http://xwzjmw.gigazu.com/?">Adobe Reader 8.1.2 / 7.0.9 Final</a>
Adobe Reader 8.1.2 / 7.0.9 Final
<a href="http://bpvswa.k2free.com/?">Nero Toolkit InfoTool 5.0.1.0</a>
Nero Toolkit InfoTool 5.0.1.0
<a href="http://wkupqu.obxhost.net/?">DVD X Copy</a>
DVD X Copy
<a href="http://mxpdqh.hostmysite101.com/?">Ad-Aware 2008</a>
Ad-Aware 2008
<a href="http://tmnfdu.hostbot.com/?">Partition Magic 8.0</a>
Partition Magic 8.0
<a href="http://dwnvri.yourfreehosting.net/?">WinZip 11.20</a>
WinZip 11.20
<a href="http://hsywjh.5nxs.com/?">SpywareBlaster</a>
SpywareBlaster
<a href="http://axshdt.iwebsource.com/?">Super DVD Ripper</a>
Super DVD Ripper
<a href="http://oqxuoh.8tt.org/?">WDM_R188.exe 5.10.0.5574</a>
WDM_R188.exe 5.10.0.5574