I don't know a direct way using (in)
but this technique does the work:

Code:
declare @t  table  (id int identity,val int)
insert into @t values(9)
insert into @t values(12)
insert into @t values(11)

SELECT	 Employee.*
FROM		 STUDENT,@t
Where EmpCode = val
order by id