M Mat Dec 8, 2006 #1 In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement?
In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement?
R Rad [Visual C# MVP] Dec 8, 2006 #2 In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement? Click to expand... Yep. Like so: Select fullname, age from people where age in (50,60,70)
In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement? Click to expand... Yep. Like so: Select fullname, age from people where age in (50,60,70)
R Rad [Visual C# MVP] Dec 8, 2006 #3 In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement? Click to expand... 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...
In SQL you can use the operator "IN" in a where clause. Is it possible to use the same in an vbscript IF statement? Click to expand... 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...
M Mat Dec 9, 2006 #4 select case can do it but this is not beautiful Rad said: 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... Click to expand...
select case can do it but this is not beautiful Rad said: 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... Click to expand...
