[Firebird-devel] FW: Can you use ".." in IN statement?

[Leyne, S. <sl...@at...>]

Another suggestion from the support list regarding IN.


> From: Helen Borrie [mailto:he...@tp...]
> Sent: Thursday, November 07, 2002 10:55 PM

> The enhancement I would love to see is the ability to=20
> parameterise the items inside the comparison set.

> but how often have I wanted to pass values for a set to a SP,=20
> so that my SP could have
>=20
> where something IN (arg1, arg2, arg3, arg4)

To extend this notion one more step, it would be even better to be able
to pass a single parameter, with the list of items delimited inside.
For example:

	where something IN (Parm1)	and Parm1 =3D "1,2,3,6,7,8"


Sean

P.S. So Arno, does this meet with your 'approval'? ;-)))