Toad World® Forums

SQL Help?


Hi there,

I have a table that has a number of records like the one below :


How would the SQL go in Toad if i wanted to pull out the data and split it into each individual colums :

  • pull out the first 4 numbers without the underscore,
  • the Name without the Underscore
  • 005 by itself

Your help is much appreciated. Still new to SQL and Toad