pears.HideFromCombo

CREATE FUNCTION "pears"."HideFromCombo"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "combovis" CHAR(25) ) 
RETURNS INTEGER
BEGIN
  DECLARE "staffcombovis" CHAR(25);
  DECLARE "i" INTEGER;
  DECLARE "c" CHAR(1);
  SET "combovis" = "trim"("combovis");
  IF "isnull"("combovis",'') = '' THEN
    RETURN 0
  END IF;
  SELECT "trim"("combovisibility") INTO "staffcombovis" FROM "staff" WHERE "staffid" = "userstaffid";
  IF "isnull"("staffcombovis",'') = '' THEN
    RETURN 0
  END IF;
  SET "i" = 1;
  loop
    SET "c" = "substring"("combovis","i",1);
    IF "c" = '' THEN
      RETURN 1
    END IF;
    IF "staffcombovis" LIKE '%'+"c"+'%' THEN
      RETURN 0
    END IF;
    SET "i" = "i"+1
  END loop
END