<div>
Thanks. I got errors saying with square brackets so thanks for the validation
</div>


Thanks. I got errors saying with square brackets so thanks for the validation

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
To set a LIKE filter on a DataTable for column [Payment Type] do I use the following syntax<br />
<br />
ds.Tables(&quot;MyTable&quot;).Defau<wbr />ltView.Row<wbr />Filter = &quot;(Payment Type LIKE '*x*' OR Payment Type LIKE '*x*')&quot;<br />
<br />
OR do I use:<br />
<br />
ds.Tables(&quot;MyTable&quot;).Defau<wbr />ltView.Row<wbr />Filter = &quot;([Payment Type] LIKE '*x*' OR [Payment Type] LIKE '*x*')&quot;
</div>
</div>


Hi

To set a LIKE filter on a DataTable for column [Payment Type] do I use the following syntax

ds.Tables("MyTable").DefaultView.RowFilter = "(Payment Type LIKE '*x*' OR Payment Type LIKE '*x*')"

OR do I use:

ds.Tables("MyTable").DefaultView.RowFilter = "([Payment Type] LIKE '*x*' OR [Payment Type] LIKE '*x*')"

VB.net Filter Syntax

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,