I have a web site that uses ASP and an access database. I am trying to upgrade the access database to SQL server. How do I make a hyperlink field work properly in SQL server since it does not support hyperlink fields?

Can anyone help?