[Info-ingres] Help splitting up a varchar into pieces

[twenty-six at b-mint.net]

Hello,

Given varchar(10) data such as:

abc123
ab1234
defgh45
a987654
dd3

I need a SQL select statement to split this into the alpha portion and 
the numeric portion.   But the alpha  and numeric  parts are of variable 
length which is causing me issues.

Any idea if this is possible?   Can I use a regular expression somehow?

Cheers.