14 lines
300 B
SQL
14 lines
300 B
SQL
CREATE OR REPLACE FUNCTION splitadd (instring VARCHAR(255))
|
|
RETURNS INTEGER
|
|
NO EXTERNAL ACTION
|
|
F1: BEGIN ATOMIC
|
|
|
|
declare first INTEGER;
|
|
declare second INTEGER;
|
|
|
|
set first = REGEXP_SUBSTR(instring, '[0-9]+',1,1);
|
|
set second = REGEXP_SUBSTR(instring, '[0-9]+',1,2);
|
|
|
|
return first + second;
|
|
END
|