aonestar.public

Parameters

Name	Type	Mode
lname	text	IN
fname	text	IN
mname	text	IN (DEFAULT NULL)
title	text	IN (DEFAULT NULL)
format	character varying	IN (DEFAULT NULL)
use_title_code	boolean	IN (DEFAULT false)

Definition

declare f1 char(1);
declare f2 char(1);
declare f3 char(1);
declare f4 char(1);
begin
    title = coalesce(title, '');
    fname = coalesce(fname, '');
    lname = coalesce(lname, '');
    --mname = coalesce(mname, '');
    IF (format is null or format = '') THEN
        format = fn_sys_param('SYSTEM', 'NAME_FORMAT', 'LFMT');   
    END IF;

    f1 = substring(format from 1 for 1);
    f2 = substring(format from 2 for 1);
    f3 = substring(format from 3 for 1);
    f4 = substring(format from 4 for 1);

    return trim(case substring(format from 1 for 1)
                    when 'T' then title
                    when 'F' then fname
                    when 'L' then lname
                    when 'M' then coalesce(' '||mname,'')
                    else ''
                 end
                 || case substring(format from  2 for 1)
                       when 'T' then ' ' ||title
                       when 'F' then ' ' ||fname
                       when 'L' then ' ' ||lname
                       when 'M' then coalesce(' '||mname,'')
                       else ''
                    end
                 || case substring(format from 3 for 1)
                       when 'T' then
                           case when (substring(format from 4 for 4) in ('T','F','L','M'))
                              then ' '||title
                              else ', '||title
                           end
                       when 'F' then ' ' ||fname
                       when 'L' then ' ' ||lname
                       when 'M' then coalesce(' '||mname,'')
                       else ''
                    end
                 || case substring(format from 4 for 4)
                       when 'T' then iif(title='', '', ', ' ||title)
                       when 'F' then ' ' ||fname
                       when 'L' then ' ' ||lname
                       when 'M' then coalesce(' '||mname,'')
                       else ''
                    end);
end;

fn_fullname

Parameters

Definition