title: Query for blank white space before AND after a number string
body: <p><img src="https://i.stack.imgur.com/nKn7Z.jpg" alt="enter image description here">How would i go about constructing a query, that would return all material numbers that have a "blank white space" either BEFORE or AFTER the number string? We are exporting straight from SSMS to excel and we see the problem in the spreadsheet. If i could return all of the material numbers with spaces.. i could go in and edit them or do a replace to fix this issue prior to exporting! (the <code>mtrl</code> numbers are imported in via a windows application that users upload an excel template to. This template has all of this data and sometimes they place in spaces in or after the material number). The query we have used to work but now it does not return anything, but upon export we identify these problems you see highlighted in the screenshot (left screenshot) and then query to find that <code>mtrl</code> # in the table (right screenshot).  And indeed, it has a space before the 1. </p>
  
  <p><img src="https://i.stack.imgur.com/vYP8W.jpg" alt="enter image description here"></p>
  
  <p>Currently the query we use looks like:</p>
  
  <pre><code>SELECT  Mtrl
  FROM dbo.Source
  WHERE Mtrl LIKE '% %'
  </code></pre>