title: DataTable.Select with ' (single quote) Character in the query vb.net
body: <p>I have a string like <code>"Hello'World"</code> and a DataTable with some records in it. One of those records is <code>"Hello'World".</code></p>
  
  <p>The problem is, when I do a .Select in the DataTable, it only tries to search for the "Hello" part and throws an error on "World" because it interprets the ' (single quote) like the closing quote on sql.</p>
  
  <pre><code>DataTable.Select("text = 'Hello'World'")
  </code></pre>
  
  <p>I have gone through msdn doc, and it says I can escape some characters with [] brackets or f.slashes \, but I just can't figure out: <code>.select("text = 'Hello[']world'")</code></p>
  
  <p>I've done some reading: <a href="http://www.vbforums.com/showthread.php?t=522918" rel="nofollow noreferrer">Verbatim in vb - c#</a> and "jmcilhinney" explains it really well. BUT, it did not answer my question for what I want to do. In stackoverflow.com, <a href="https://stackoverflow.com/questions/6221770/how-can-i-strip-a-single-quote-from-a-datatable-select-query-in-c">a same question is posted but in c#</a>, but I can't find a way to use @ in vb.</p>
  
  <p>Can you please redirect me to more doc, examples or any one of you have ever encountered this problem?</p>