title: Filter datasource where column like/contains VB.NET
body: <hr>
  
  <p>UPDATE</p>
  
  <p>Thanks to Hanlet the problem is solved, the syntax is like so:</p>
  
  <pre><code>source1.Filter =  "[Column] LIKE '%" &amp; TextBox1.Text &amp; "%'"
  </code></pre>
  
  <p>Also for anyone interested, this is the syntax for performing the above on multiple criteria:</p>
  
  <pre><code>source1.Filter = "[Column1] LIKE '%" &amp; TextBox1.Text &amp; "%' OR [Column2] LIKE '%" &amp; TextBox1.Text &amp; "%'"
  </code></pre>
  
  <hr>
  
  <p>I currently have code to filter my datasource where the column 'Customer Name' equals the text in the text box.</p>
  
  <p>However, what I want is a filter that is similar to the LIKE function in sql, so if the customer name is 'John' and the user inputs 'Jo' into the text box, it will filter all customers who's name is LIKE/contains 'Jo'</p>
  
  <p>This is the current filter code (if you want the code showing how the data is bound just ask):</p>
  
  <pre><code> Dim source1 As New BindingSource()
   source1.Filter = "[Customer Name] = '" &amp; TextBox1.Text &amp; "'"
   dTableMain.Refresh()
  </code></pre>
  
  <p>Thanks for any help!</p>