Creating hyperlink in TSQL

I am trying to insert a Hyperlink into an email using TSQL.

Can anybody give me some advice on how to create such an hyperlink?
And would it be the same method for a mailto link?

Many thanks

NetWRX

let's say you were selecting a field called URL from a table called table1, you could do something like this:

select '<a href="' + URL + '">Click Here!</a>' from table1

for mailto, assuming a field called emailaddress:

select '<a href="mailto:' + emailaddress + '">' + emailaddress + '</a>' from table1

Thanx anon but that is not the solution

Its is still appearing in text format and not hyperlink :confused:

Anybody please help

:starts pulling hair out:

Could you explain how you are sending mail with tsql in the first place?

Hi anon,

I am using xp_sendmail.

The adress is coming from database using an on insert trigger.

So the aim is to get link from database and convert it into a hyperlink in the email.

hope this gives you some understanding.

That clears things up a bit. xp_sendmail is not capable of sending a HTML mail. You would probably want to look at using another method of send mail...check out this article from microsoft on sending mail without xp_sendmail:
http://support.microsoft.com/defaul...b;en-us;Q312839