title: sql server - how do i find rows with whitespace in a column
body: <p>I want to do something like </p>
  
  <pre><code>select * from X where string.IsNullOrWhiteSpace(a)
  </code></pre>
  
  <p>Column a is <code>NOT NULL</code> </p>
  
  <p>So what would be the equivalent of C# <code>string.IsNullOrWhiteSpace</code> in T-SQL to get all rows where column a has only whitespace (combination of multiple spaces or tabs)?</p>
  
  <p>Also, I would rather avoid using <a href="/questions/tagged/clr" class="post-tag" title="show questions tagged &#39;clr&#39;" rel="tag">clr</a> functions.</p>