Please put the answer to this question as the first line of your bid: 10 + 5 = ?
I sell books and need to fix one of the columns in my database, the edition column.
The editions come in many different formats, and I need a way of parsing out this information in a reliable way.
For example, a 3rd edition textbook may have any of the below values currently for edition:
3, 3rd, 3/E, third, 3rd Revised ed., 3rd ed., and on and on.
I think I want an INT returned by the function, but this can be discussed. So in the example, if "third" was the parameter, 3 would be returned.
Please see the attached file for a complete list of edition values currently in the database. Note that not all of the values will be possible to return an INT for(large type, International, etc). In this case, I think NULL can be returned.