title: T-SQL: issue with string concat
body: <p>I have a set of audio files with names GreenLine1.mp3, GreenLine2.mp3 e.t.c. I'm going to write them into a table as BLOB (I use MS SQL Server'08), here's my sql request:</p>
  
  <pre><code>DECLARE @aud AS VARBINARY(MAX)
  DECLARE @num AS INT    
  -- Load the audio data
  SET @num=1
  WHILE (@num&lt;38)
  BEGIN;
  
  SELECT @aud = CAST(bulkcolumn AS VARBINARY(MAX))
        FROM OPENROWSET(
              BULK
              'C:\Users\Ilya\folder\GreenLine' + CAST(@num AS VARCHAR) + '.mp3',
              SINGLE_BLOB ) AS x
  
  -- Insert the data to the table          
  INSERT INTO Mb2.dbo.Audios (Id, [Content])
  SELECT NEWID(), @aud
  SET @num = @num + 1
  END;
  </code></pre>
  
  <p>I have an error: Incorrect syntax near '+', expecting ',' or ')'.</p>
  
  <p>If I try to write </p>
  
  <blockquote>
    <p>'C:\Users\Ilya\folder\GreenLine' +
    CAST(@num AS VARCHAR) + '.mp3'</p>
  </blockquote>
  
  <p>into a variable and put it after BULK, I get Incorrect syntax near @variable, expected STRING, or TEXT_LEX</p>