Re: Help : PL/SQL Cursor Limitations

phil chang <pxchang0_at_sunspot.wcc.com> wrote in <5r8b7m$lr6$1_at_news-2.csn.net>...
> I'm coming into this late, without the original posting in front of me,
 but I
> believe the following will work in this case.
>
> select Emp_Name
> from Employee
> where
decode(sign(instr(:global.string,ltrim(to_char(Emp_id,'09')))),1,Emp_id,0) = Emp_id;
>

Thank you, Phil, I enjoy your idea!
It realy work, but why not
 where instr(:global.string,ltrim(to_char(Emp_id,'09'))) > 0 ?
All the best, Nikolay Received on Fri Jul 25 1997 - 00:00:00 CEST