title: Adding Dividers
body: <p>I currently have a Storedproc t hat is returning values for me to bind with a gridview in asp.net.  One thing I want to do is combine two fields into one seperated by a / but I cannot seem to get this working.</p>
  
  <p>Here is my stored proc</p>
  
  <pre><code>DECLARE @SQL VARCHAR(MAX);
  
  BEGIN
  SET @SQL = N'SELECT SYSTEM AS ''System''
              , ENTN AS ''Entity''
              , MED_CTR AS ''Medical Center''
              , MED_CTR_LEVEL AS ''Medical Center Level''
              , DEPT_ID AS ''Department ID''
      FROM V_ROLLUP_SYSTEM_DESC_REV1
      WHERE (DEPT_ID = '+CONVERT(VARCHAR,@DEPTCODE)+')
          AND SYSTEM IN ('+@SYS+')'
  PRINT(@SQL)
  EXEC(@SQL)
  </code></pre>
  
  <p>So I want to combine MED_CTR with MED_CTR_LEVEL seperated by a "/" and labeled as Medical Center/ Level.  I cant seem to combine it thus far since every method I have tried to add a "/" in it has returned me nothing.</p>