[SQL] SELECT substring with regex

[T E Schmitz]

I would like to split the contents of a column using substring with a 
regular expression:

SELECT
 substring (NAME, '^\\d+mm') as BASE_NAME,
 substring (NAME, ??? ) as SUFFIX
FROM MODEL
The column contains something like
"150mm LD AD Asp XR Macro"
I want to split this into
"150mm", "LD AD Asp XR Macro"

How can I extract the bit following the matching substring?

--


Regards,

Tarlika Elisabeth Schmitz

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings