title: Identify the left and right part of the decimal (varchar)
body: <p>I need to transform varchar values like this <code>1250</code> to decimal values <code>12.50</code>.</p>
  
  <p>Some examples :</p>
  
  <pre><code>16500 165.00
  17525 175.25
  1015  10.15
   955  9.55 
  </code></pre>
  
  <p>I actually use this to do it <code>stuff(@total,len(@total)-1,0,'.')</code> and then insert my value to a decimal column in my table. This works until the varchar value is more than <code>100</code> = <code>1.00</code>. Actually if I get a value like <code>5</code> = <code>0.05</code> (5 cents) I have an issue and it doesnt work. It must also works with negative values like <code>-3</code> = <code>-0.03</code> </p>