title: Error when running SQL stored procedure coversion failed when converting date and/or time from character string
body: <pre><code>DECLARE @i varchar(13)
  DECLARE @Year varchar(30)
  
  SET @i = 2
  SET @Year = 2013
  
  SELECT SUM(CAST([totalAfterMultiplier] as money)) as 'totalAfterMultiplier' FROM [postfinanceAfterMultiplier] 
                      WHERE CAST([ORDER] as date) &gt;= '01/'+@i+'/'+ @Year +'' AND CAST([ORDER] as date) &lt;= '31/'+@i+'/'+ @Year +''
  </code></pre>
  
  <p>I am getting this error: Conversion failed when converting date and/or time from character string.</p>
  
  <p>All values in the database are <code>varchar(50)</code></p>
  
  <p>I have looked at the other posts and can't seem to get it working</p>
  
  <p>Thank you all for your help</p>