1 Reply Latest reply on Jan 20, 2013 1:14 AM by Richard Leeke

    Converting string to a number "invalid number" from Oracle DB

    Brad Mills

      INT(TRIM(LEFT("[FIELD]", 4) ) )

       

      This is the closest I've got so far.

       

      Some fields had a range in them.. Like 1546.00-2923.00

       

      Others 0.00, others 1513.00

       

      I'm guessing at some point in the 30+ million rows there's some text...

       

      What can I do without messing with the source database?