title: Select command on DataRow using the like command
body: <p>I have a line of code that I want to return all the rows in a dataset where a column has a name like </p>
  
  <pre><code>var rows = data.Tables[0].Select("Name like '" + username+ "['");
  </code></pre>
  
  <p>So basically I want to return all the rows where a column called Name has a username with a <code>[</code> just after its</p>
  
  <p>eg</p>
  
  <pre><code>John [Smith]
  John [Kelly]
  </code></pre>
  
  <p>the function above should return both of these because there is a <code>[</code> just after their name</p>