title: Extract last number out of existing one
body: <p>I have to extract the next number out of given numbers. My table contains numbers like below. The main product is always with .1 at the end and could or not contains his subproducts e.g:</p>
  
  <pre><code>07.0001.1 (main product)
  07.0001.2 (his sub)
  07.0001.3 (his sub)
  etc..
  
  01.1453.1
  01.1453.2
  03.3456.1
  03.3456.2
  03.3456.3
  03.5436.1
  03.5436.2
  03.5436.3
  03.5436.4
  12.7839.1
  12.7839.2
  12.3232.1
  12.4444.1
  12.4444.2
  13.7676.1
  </code></pre>
  
  <p>i want to pass first to digits of a number to the query and based on that get all which starts with that and then get the highest number out of next four and return this number + 1. </p>
  
  <p>So if we would take above example inputs if i say <code>12</code> then it should find this product: <code>12.7839.x</code> and return <code>12.7839 + 1</code> so <code>12.7840</code></p>
  
  <p>Another example if i say <code>03</code> then should find <code>03.5436</code> so <code>03.5436 + 1</code> so should return <code>03.5437</code></p>
  
  <p>Hope you know what i mean.</p>
  
  <p>I am not so familiar with SQL but this is how far i am:</p>
  
  <pre><code>select * from tbArtikel where Nummer LIKE '12.%'
  </code></pre>