hi all
i have made a procedure. In which i use IN condition but the condition is not working.
create procedure getbalance
@acode varchar(2000),
@csh varchar(2000)
as
select * from tablename where acode = @acode and c_sh in (@csh)
when i pass @acode=111 and @csh='PNW'
then this procedure work
but i pass @acode=111 and @csh =('PNW','PPL')
then this procudre doesnot work
please suggest