title: SQL Server : find rows that contains spaces
body: <p>I'm looking for fast way to see all rows in table that contains any spaces.</p>
  
  <p>For starters, I tried to see which rows starts with space by this query:</p>
  
  <pre><code>select * 
  from MyTable 
  where ColumnName like ' %'
  </code></pre>
  
  <p>but I got 0 results, although I can see there are rows with spaces.</p>