extract numeric value from a string.

[dixie]

Hi at all, I've this necessity.
In a table I've a field popolated by a string where the first (not
costant lenght) part are number and the second part caracter.
I want extract, in other field, the first part and the second in another
field.
There is a function to obtained it?

Tks in advance

Paolo
-- 
dixie <dixie@stripped>