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 gib\ve me some idea on this?

Generally after IN statement there should be set of values .....but in aabove query it is not..?
but u can try this one
 set @A='MIS';
then excute ur qry.

for more specific write where d.DeptDesc=@A simply



With thanks
rajesh,
India