I have a column called "invoice_identifiers" that has data as follows:
What is need to write a SQL statement that
1) separates the alpha from the numeric
2) places them into individual fields
For example, the numeric part would go into a field invoice_number and the alpha part would go into invoice_letters.
Any help and examples are greatly appreciated.