title: SQL query to extract a number and its decimal variations
body: <p>I have column with all kinds of numbers, I am specifically trying to extract numbers that have either </p>
  
  <pre><code>555
  </code></pre>
  
  <p>or</p>
  
  <pre><code>555.xx
  </code></pre>
  
  <p>or</p>
  
  <pre><code>555.x
  </code></pre>
  
  <p>The output should look like this</p>
  
  <pre><code>555
  555.1
  555.5
  555.9
  555.58
  555.22
  .
  .
  </code></pre>
  
  <p>IE I need an sql query that will return the rows that have just the number 555 with any decimal fraction from my column of arbitrary numbers.</p>