<div>
Can you explain more clearly may be by sending some screen shots of input and output
</div>


Can you explain more clearly may be by sending some screen shots of input and output

<div>
based on my understanding for the requirement and referring to sample of Stefan in ID: 42431385, shouldn't that <b>INTERSECT </b>should be used instead of EXCEPT?<br />
<br />
provided:<br />
<br />

<pre><code id="code-20-42432066-1">INSERT INTO @Batches ( BatchNumber )
VALUES ( 1 ) ,
       ( 5 ) ,
       ( 7 ) ,
       ( 9 );

DECLARE @Parameter VARCHAR(MAX) = '1,3,5,7';</code></pre>
</div>


based on my understanding for the requirement and referring to sample of Stefan in ID: 42431385, shouldn't that INTERSECT should be used instead of EXCEPT?

provided:



INSERT INTO @Batches ( BatchNumber )
VALUES ( 1 ) ,
       ( 5 ) ,
       ( 7 ) ,
       ( 9 );

DECLARE @Parameter VARCHAR(MAX) = '1,3,5,7';

<div>
@Ryan, indeed.. misinterpret the OP's requirement.
</div>


@Ryan, indeed.. misinterpret the OP's requirement.

<div>
Sorry for late get back<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I have a dataset being returned from SQL Server into my web form<br />
<br />
It has a column &nbsp;called BatchNumber that can be from 1 to 1000 rows<br />
<br />
<br />
I also have a comma seperated string <br />
strMyList = &quot;1,3,5,7&quot;<br />
<br />
I would like to remove from strMyList any value not in the &quot;longer list&quot;<br />
<br />
So that if the dataset does not have BatchNumber 3 then<br />
strMyList would = &quot;1,5,7&quot;
</div>
</div>


I have a dataset being returned from SQL Server into my web form

It has a column  called BatchNumber that can be from 1 to 1000 rows


I also have a comma seperated string 
strMyList = "1,3,5,7"

I would like to remove from strMyList any value not in the "longer list"

So that if the dataset does not have BatchNumber 3 then
strMyList would = "1,5,7"

vb.Net loop through Dataset.Table(0)

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).