Hi, i am a new bee in MySql.
This is how i do testing for my stored procedured.

declare @A VARCHAR(45);
@A='MIS';

select
d.DeptDesc
from dept d
where d.DeptDesc in(@A)

The result i get from this query is nothing.There is really a deptDesc=MIS in the table.I try with SQL Server 2005and no problem.
Can anyone tell give me some idea on this?