title: Stored procedure does not return anything
body: <p>It is should be no problem to find but after long hours at my job I cannot notice what I'm doing wrong here.</p>
  
  <p>There is very simple stored procedure:</p>
  
  <pre><code>ALTER PROCEDURE MyProc  
  @input char(10)
  
  AS
  
      BEGIN
          SET NOCOUNT ON;
          SELECT isonum 
          FROM iso where isonum LIKE '%' + @input + '%'
          ORDER BY isonum
      END
  </code></pre>
  
  <p>when executing a query: select <code>isonum from iso where isonum like '%2333%'</code> - I get the data,but when executing the stored procedure: </p>
  
  <p><code>exec MyProc '2333'</code> - I get nothing???</p>
  
  <p>What's wrong here?</p>