apzl_leasing/src_sql/function/getProjectNameByID.sql

create function getProjectNameByID(projectID varchar(40)) returns varchar(80)
return (select project_name from lb_project_info where id=projectID);