DB2 WSE 8.1 FP 5
Red Hat Linux AS 2.1
(LUW)
I am looking to write a stored procedure
GETNUMBER(p_input VARCHAR(50)) RETURNS Integer
that will return to me only the numeric portion of
alphanumeric p_input, dropping the alpha portion(s).
So,
GETNUMBER('B999') would return 999
GETNUMBER('B888A') would return 888
GETNUMBER('ABCDEFG123') would return 123
GETNUMBER('12345YXEWQ') would return 12345
You get the idea.....
I have this written as a Java UDF, but have had nothing but
headaches w/ v8 FP5 Java VM FMP issues.
Can this be written as a stored procedure?
Any help appreciated.
aj