title: Incorrect Syntax Near '+' - SQL/TSQL
body: <p>Trying to do this (in SQL Server Management Studio)</p>
  
  <pre><code>DECLARE @fun as int
  SET @fun = 40
  PRINT 'String' + 'Hello!'
  
  EXEC msdb.dbo.sp_senddbmail
      @profile_name = 'Some working profile',
      @recipients = 'someone@example.ca',
      @subject =  'String' + 'Hello!',
      @body = 'Test email sendout'
  </code></pre>
  
  <p>Getting this error :</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 8<br>
    Incorrect syntax near '+'.</p>
  </blockquote>
  
  <p>Notice the first concatenation works, second doesn't. </p>
  
  <p>The steps I've taken:</p>
  
  <p>Retyped it all out (so its not a copy paste error). Tried changing it to ('String' + 'Hello!') and get error <code>Incorrect syntax near '('.</code> So I'm feeling a bit lost.</p>
  
  <p><strong>EDIT 2:</strong> I've changed the example because the same error happens when its two strings, no casts involved</p>