suffix := 'II';
temp := BTRIM(REGEXP_REPLACE( temp, E'II', '' ));
END IF;
- IF temp like '%IV%' THEN
- suffix := 'IV';
- temp := BTRIM(REGEXP_REPLACE( temp, E'IV', '' ));
- END IF;
IF temp ~ ',' THEN
family_name = BTRIM(REGEXP_REPLACE(temp,'^(.*?,).*$','\1'));