kingbase
create function substring_index(f_string in text, f_delimiter in varchar2, f_position in number) return text
as
o_string text;
v_direction int;
v_instr_pos int;
begin
IF f_position = 0 THEN
RETURN '';
END IF;
if f_position > 0 then
v_direction := 1;
select instr