title: LIKE query on DataTable using LINQ
body: <p>Ive just started learning Linq. Ive just created a sample test like this.</p>
  
  <pre><code>            Dim dt As New DataTable
  
              Dim dc As New DataColumn
  
              dc.ColumnName = "Test"
              dt.Columns.Add(dc)
  
              dt.Rows.Add("Test")
              dt.Rows.Add("One test")
              dt.Rows.Add("Second test")
  
              Dim results = From myRow In dt.AsEnumerable
                            Where myRow("Test") = "Test"
                            Select myRow
  
  
              For Each Row In results
                  Console.WriteLine(Row.Item(0).ToString())
              Next
  </code></pre>
  
  <p>This returns the first row in the iteration. </p>
  
  <p>But what if i want to use a LIKE operator using %? I cant get it to work.</p>
  
  <p>Ive tried</p>
  
  <pre><code>Where myRow("Test") LIKE "Test%"
  </code></pre>