pears.GetQuestNumber

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GetQuestNumber" IS 
{CREATE FUNCTION GetQuestNumber 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN stagloc CHAR(3),IN stagid CHAR(3),IN sparentid CHAR(20))
RETURNS DOUBLE
BEGIN
  DECLARE rv DOUBLE;
  DECLARE tagval DOUBLE;
  SET rv=NULL;
  SELECT MAX(VALUE) INTO tagval FROM tagvalue WHERE taglocation = stagloc AND id = sparentid AND tagid = stagid;
  IF isnull(tagval,0) <> 0 THEN
    SET rv=tagval
  END IF;
  RETURN(rv)
END
}