My LINQ Query below works fine
There are about 500 empty or zero length records being inserted into the results set.
How do I exclude those records in the select?
Dim Query = _
(From Region In dataset1.Tables(0) _
Select Region.Field(Of String)("Region")).Distinct().OrderBy(Function(item) item).ToList