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

    Varchar to Number conversion

      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.