title: Wildcard of Number in SQL Server
body: <p>How to match numbers in SQL Server 'LIKE'.</p>
  
  <pre><code>SpaceName
  ------------ 
  | New_Space_1
  | .
  | .
  | New_Space_8 
  | New_Space_9
  | New_Space_10
  | New_Space_11
  | New_Space_SomeString
  | New_Space_SomeString1
  </code></pre>
  
  <p>Above is  my table contents.
  I want to get only records ending with Numeric chars, ie I want the records from <code>New_Space_1</code> to <code>New_Space_11</code>.</p>
  
  <p>Don't want <code>New_Space_SomeString</code> and <code>New_Space_SomeString1</code></p>
  
  <p>I have some query like this.</p>
  
  <pre><code>SELECT SpaceName FROM SpaceTable
      WHERE SpaceName LIKE 'New_Space_%' 
  </code></pre>
  
  <p>But this returns all records.</p>