3 Replies Latest reply: Feb 13, 2013 4:38 AM by prassu RSS

    Substring behaviour in obiee 10g

    prassu
      Hi,
      How the substring function will work in obiee 10g...

      Substring('89.55' from -2 for 5) ,it returns 89
      Substring('89.55' from -2 for 3) ,it returns 0

      I am not able to understand the behaviour of substring with the negative arguments...

      i referred this link ...
      http://www.obieefans.com/page/5/

      Can anyone please explain me the execution.....

      thanks,
      prassu