Using "In" Statement in code

[aggieval]

I am sure there is a simple answer, but I can't find it. Is it possible to use an "in" statement in code? I don't want to use multiple "or"s, but "in" doesn't work. Any help?

Thanks

 

[Junior1544]

why not a like "*hi*" i know in certain places i use this and it works like you want an in statement... there are limitations, but i don't use it much...

--James JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[TrojanRabbit]

Another way is InStr(1,<string to search>,<string to search for>).

 

[jimmythegeek]

I have used the In keyword many times in Access:

For text:
SELECT * FROM land WHERE Parcel IN(&quot;1234&quot;, &quot;1235&quot;, &quot;1236&quot;, &quot;1237&quot


For Number:
SELECT * FROM land WHERE Parcel IN(1234, 1235, 1236, 1237) Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[JohnYingling]

For a finite number of constants or variables use SELECT.
Select Case lngCode
Case 1, 2, 3, 5, 8, 13, 21, 34, 55 ' Fibonacci numbers
.....
Case else
....
End Select

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[aggieval]

Thanks John, that's exactly what I needed.