title: oracle if 0, like if null (nvl)
body: <p>oracle has a nice built in function for doing if null, however I want to do if = 0; is there a simple way to do this?</p>
  
  <blockquote>
    <p>nvl(instr(substr(ovrflo_adrs_info,instr(ovrflo_adrs_info,'bldg')+5),' '),
                  length(substr(ovrflo_adrs_info,instr(ovrflo_adrs_info,'bldg')+5))))</p>
  </blockquote>
  
  <p>This is going as a parameter to a substr function.</p>
  
  <p>If <code>instr(substr(ovrflo_adrs_info,instr(ovrflo_adrs_info,'bldg')+5),' ')</code> is <code>!= 0</code> then I want that value, otherwise I want the value of <code>length(substr(ovrflo_adrs_info,instr(ovrflo_adrs_info,'bldg')+5))</code></p>
  
  <p>is there an easy way to do this?</p>