7 Replies Latest reply: Jan 20, 2011 1:59 AM by user7351276 RSS

    Varchar to Number conversion

    user7351276
      Hi,
      Am trying to convert a varchar to number using to_number

      select (substr(value1,69,10)) from test .
      this gives 00000000.1


      but when I try to convert this to number like
      select (to_number(substr(value1,69,10))) from test
      then gives "invalid number" error message.

      Please let me know if statement is wrong here.