pears.ShiftConsultants

CREATE FUNCTION "pears"."ShiftConsultants"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "entby" CHAR(20),IN "entat" TIMESTAMP,IN "fillby" CHAR(20),IN "fillat" TIMESTAMP ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  SET "rv" = '';
  IF "entby" IS NOT NULL THEN
    SET "rv" = "string"('Entered by: ',(SELECT "userid" FROM "staff" WHERE "staffid" = "entby"),' ',"dateformat"("entat",'dd/mm/yyyy hh:nn'),'  ')
  END IF;
  IF "fillby" IS NOT NULL THEN
    SET "rv" = "string"("rv",'Filled by: ',(SELECT "userid" FROM "staff" WHERE "staffid" = "fillby"),' ',"dateformat"("fillat",'dd/mm/yyyy hh:nn'))
  END IF;
  RETURN "rv"
END