Dynamic URL Based on other field contents

Hi,
i have a list table that contain a URL that i want the logged-in user to click.

and on clicking, it popup another window where the path is dynamic

base on logged in user's parameters.
Here's the details.

1. Table look like this:
   
   -----------------------------------------
   
   Account Name | Contact | URL Link
   
   -----------------------------------------
   
2. URL Link is a http path with some part of it, concatentated with account name and contact:
   
   eg. http://www.ghome.com/Andrew/97620044
   I implemented dynamic URL using SQL View with the following SQL Query:
   
   SELECT `Account Name`, `Contact`, CONCAT("http://www.ghome.com/",`Account Name`,'Contact`) As `URL Link`
   
3. The URL Link should be displayed as a picture. so that on clicking, the
   
   pop up window will be open and point to the URL address. (how to achieve this ?).
   I tried using view as hyperlink, but i can only put a name for the URL not an image or icon i want to display to the user.
   Thanks
   
   Dex