Thank You Sandeep

Works Perrfect :)

Hans

=====================================================
Sandeep wrote:

>
> On 1 Oct 2001, at 22:46, hans@... wrote:
>
> > How do I resolve the fact that I can't pass '1,2,3' in NUMBERS
> >
> > CREATE PROCEDURE TEST (NUMBERS VARCHAR(30))
> > RETURNS ( NAME VARCHAR )
> > AS
> >
> > BEGIN
> > FOR SELECT NUMBER FROM TABLE
> > WHERE NUMBER IN ( :NUMBERS )
> > INTO :NAME DO
> > SUSPEND;
>
> try this
>
> select number from table
> where :numbers containing number
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/