title: DB2 for IBM i (AS400) query substr
body: <p>I have 48/50 g in a as400 database and I want to (query)substr before the "/" and before the space between 50 and g.</p>
  
  <p>Result I should get is 50</p>
  
  <p>I'm searching for hours now and try and try but no luck.</p>
  
  <p>any help is welcome.</p>
  
  <p>Thanks!</p>