Does VB.NET have functionality similar to TSQL's "IN"?

Question

In TSQL..

IF MyVal IN (1, 2, 3, 4, 14) BEGIN ... END

Is there a way to do this in VB.NET?

Is it possible to check for the existence of an integer in a set of integers inline?

Such as:

If MyVal in (1, 2, 3, 4, 14) Then ... End If

Community · Accepted Answer · 2017-05-23 12:27:49Z

Arrays are an implementation of IEnumerable so with the System.Linq import a shorthand version of Tim Schmelter's answer would be:

{1,2,3,4,14}.Contains(MyVal)

Arrays also have an explicit implementation of IList.Contains, so without LINQ a perhaps less elegant alternative is:

DirectCast({1,2,3,4,14}, IList).Contains(MyVal)

Tim Schmelter · Accepted Answer · 2012-03-31 00:10:28Z

For example List.Contains Method

Dim MyVal = 4 Dim MyValues = {1,2,3,4,5,6,7}.ToList MyValues.Contains(MyVal)

MyValues.Sort() Dim contains = MyValues.BinarySearch(MyVal) > -1

MyValues.Any(Function(item)item=MyVal)

This is a very good answer. I did not know you could create and populate a list inline like this.

2 Answers 2