title: This string has a value I need to extract and its usually at the end of the string
body: <p>Can someone help me please?
  Eg.</p>
  
  <p>1 x E10,Day rate per hour,1  </p>
  
  <p>1 x E10  </p>
  
  <p>1 x E2A,"As E2 but with wireless roomstat, also assumes power available within 2m (this code only)",2.5 </p>
  
  <p>I got thousands of rows like the sample above and would like to extract the last figures before the comma from the right</p>
  
  <p>How can I extract that figures from the string please using SQL script?</p>
  
  <p>From the three samples above, I would please like to see something like this:</p>
  
  <p>1  </p>
  
  <p>this should be blank or 0 since the expected figure is not there in this case    </p>
  
  <p>2.5 </p>
  
  <p>I think I need to use a substring and charindex but cannot get it working.</p>
  
  <p>Thanks in advance for your help</p>