title: Oracle SQL Find A String & Work Backwards
body: <p>What I would like to do, is to locate a particular string within a result and then work backwards from that string to obtain what I need. So as an example, let's say I have a result of "This thing is heavy at 500KG no matter what". I want to find "KG" and then work backwards to obtain the "500KG". </p>
  
  <p>The reason I want to work backwards from KG is that the results can have varying strings like "This thing is heavy at 500 kg" or "500 - This thing is heavy 500Kg" etc. The only constant is the KG (even in it's varying state).</p>
  
  <p>I'm using regexp_instr and substr to narrow the result down to something like "This thing is heavy at 500KG" - essentially finding KG and removing everything after it.</p>
  
  <p>Suggestions?</p>