title: How to use like in stored procedure with int parameter?
body: <p>I 've used the Query Builder tool of Visual Studio 2008 to build a stored procedure. This is the preview script:</p>
  
  <pre><code>IF EXISTS (SELECT * 
               FROM sysobjects 
              WHERE name = 'SelectQuery' AND user_name(uid) = 'dbo')
      DROP PROCEDURE dbo.SelectQuery
  GO
  
  CREATE PROCEDURE dbo.SelectQuery
  (
      @StudentID int
  )
  AS
      SET NOCOUNT ON;
  SELECT        StudentID, StudentName, StudentPhone, StudentAddress, 
                StudentBirthDay, StudentDescription, StudentStatus
  FROM            tbl_Student
  WHERE        (StudentID LIKE '%' + @StudentID + '%')
  GO
  </code></pre>
  
  <p>But when I tried to execute it, I got an error:</p>
  
  <pre><code>Error Message: Conversion fail when converting the value '%' to datatype int.
  </code></pre>
  
  <p>Please help me!</p>