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?