«

In SQL you can use the operator "IN" in a where clause.

Is it possible to use the same in an vbscript IF statement?

On Fri, 8 Dec 2006 13:34:22 -0500, Mat wrote:

> In SQL you can use the operator "IN" in a where clause.
>
> Is it possible to use the same in an vbscript IF statement?

Yep.

Like so:

Select fullname, age from people where age in (50,60,70)
--
Bits.Bytes
http://bytes.thinkersroom.com

On Fri, 8 Dec 2006 13:34:22 -0500, Mat wrote:

> In SQL you can use the operator "IN" in a where clause.
>
> Is it possible to use the same in an vbscript IF statement?

Sorry, less haste, less waste!

Not sure VBScript can do that...

Closes thing would be to put what you want in an array or some such
collection then process it in a foreach loop I'd think...
--
Bits.Bytes
http://bytes.thinkersroom.com

select case can do it but this is not beautiful

"Rad [Visual C# MVP]" <> wrote in message
news:1x669alf46wuv$....
> On Fri, 8 Dec 2006 13:34:22 -0500, Mat wrote:
>
>> In SQL you can use the operator "IN" in a where clause.
>>
>> Is it possible to use the same in an vbscript IF statement?
>
> Sorry, less haste, less waste!
>
> Not sure VBScript can do that...
>
> Closes thing would be to put what you want in an array or some such
> collection then process it in a foreach loop I'd think...
> --
> Bits.Bytes
> http://bytes.thinkersroom.com