"in" operator in VB?

Hi,

Is there any Operator like "in" in VB which have the similar function as in SQL?

What I want to do is:


if x="a" or x="b" or x="c" then
'do something
end if

May I use this:
if x in ("a","b","c") then
'do something
end if

Thanks!


Regards,

Michi
MCSE, MCDBA

Try this maybe...


Select Case x
case "a" or "b" or "c":
'do something
End Select

Yes, it is a work around if there is no such operator. Thanks.

Regards,

Michi
MCSE, MCDBA

Like = is a new Vb6 operator
ie:
if x like "[a-b-c]" or x like "[A-B-C]" then
end if

'this does work
private Sub Command1_Click()

Dim vntIn
vntIn = InputBox("input a letter")
If vntIn Like "[A-C]" then
MsgBox "input= A,B or C"
ElseIf vntIn Like "[DEFabc]" then
MsgBox "input = D,E,F, a,b or c"
ElseIf vntIn Like "*#" then
MsgBox "input: a keystroke and a number"
End If

End Sub




Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

Thanks for your suggestion. But I think the "Like" operator does not very useful when the selective strings have no comparison part except for the meanings. For example, how can we use "like" to translate the following:

If x in ("cat", "dog", "fish") then .....

Anyway, thanks again.


Regards,

Michi