title: Converting int to string when setting up a hyperlink
body: <p>I'm new to Microsoft SQL Server but just need a slight alteration to the code below. I'm trying to set up a string which will be used as a hyperlink. It works apart from when I try to add <code>[fileID]</code> to the string because <code>[fileID]</code> is an integer.</p>
  
  <p>I've tried <code>CAST</code> and <code>CONVERT</code> but unsure exactly on the syntax to embed them in to this <code>SELECT</code> statement. it's just the <code>[fileID]</code> part that's wrong.</p>
  
  <pre class="lang-sql prettyprint-override"><code>ALTER PROCEDURE [dbo].[SelectBoxes2]
      @bootSaleDate DATE
  AS
  BEGIN
      SET NOCOUNT ON;
  
      SELECT DISTINCT 
          bootSaleDate,  
          '&lt;br/&gt;&lt;video width="100" height="250" src="catalog/videos/' + [fileId] + '" /&gt;&lt;/a&gt;' AS strText, 
          fileID,
          '&lt;a href="https://www.bargainboxes.co.uk/share-stall.aspx?oid='  + [fileID] + '"&gt;View Box&lt;/a&gt;' AS link, 
          [buyPrice] AS buyPrice
      FROM 
          [tblItems]
      ORDER BY 
          bootSaleDate DESC
  END
  </code></pre>