title: How to embed URL inside text in html?
body: <p>I have this simple code in an sql stored procedure:</p>
  
  <pre><code>Declare  @EmailBody varchar(MAX),
   @MyURL varchar(2000);
  SET @MyURL ='www.google.com';
  
  SET @EmailBody = 'Please go here: &lt;a href="' + @MyURL + '"&gt;'; 
  </code></pre>
  
  <p>Now, the <code>EmailBody</code> contains: "<em>Please go here: www.google.com</em>".
  Instead, I want the url (<em>www.google.com</em>) to be embedded inside the word <strong>here</strong>. </p>