sql - How to use like in stored procedure with int parameter? -

i 've used query builder tool of visual studio 2008 build stored procedure. preview script:

if exists (select *               sysobjects              name = 'selectquery' , user_name(uid) = 'dbo')     drop procedure dbo.selectquery go  create procedure dbo.selectquery (     @studentid int )     set nocount on; select        studentid, studentname, studentphone, studentaddress,                studentbirthday, studentdescription, studentstatus            tbl_student        (studentid '%' + @studentid + '%') go 

but when tried execute it, got error:

error message: conversion fail when converting value '%' datatype int. 

please me!

you want find rows @studentid substring of studentid? if so

where studentid '%' + cast(@studentid varchar(10)) + '%' 

should work.