Search code examples
htmlhyperlinkhref

How to embed URL inside text in html?

I have this simple code in an sql stored procedure:

Declare  @EmailBody varchar(MAX),
 @MyURL varchar(2000);
SET @MyURL ='www.google.com';

SET @EmailBody = 'Please go here: <a href="' + @MyURL + '">';

Now, the EmailBody contains: "Please go here: www.google.com". Instead, I want the url (www.google.com) to be embedded inside the word here.

Solution

  • I think your html is wrong. Try this:

    SET @EmailBody = 'Please go <a href="' + @MyURL + '">here</a>:';