title: TSQL - how to find if a column has a space char(32)?
body: <p>TSQL - how to find if a column has a space <code>char(32)</code>?</p>
  
  <pre><code>select *
  from [sometable]
  where CHARINDEX(' ', [somecolumn]) &gt; 0
  </code></pre>
  
  <p>doesn't work?  Any ideas?</p>