Currently working in Microsoft Access, writing a PTQ to an Oracle Data Warehouse.
One of the fields is a description field which holds alphanumeric strings. Sometimes all characters, sometimes the inclusion of a 9 digit number. What I want to be able to do is if there is a 9 digit number, to select it from that description field and create a new field with it.
SELECT description REGEXP_SUBSTR( * here goes the reg exp * ) "REGEXPR_SUBSTR" FROM myTable
REGEXP_SUBSTR
Any help would be greatly appreciated.