pears.PersonVacancyShiftMatch2

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."PersonVacancyShiftMatch2" IS 
{CREATE FUNCTION PersonVacancyShiftMatch2( IN @PersonID CHAR(20),IN @VacancyID CHAR(20) ) 
RETURNS CHAR(50)
BEGIN
  DECLARE "rv" CHAR(50);
  SET "rv" = (SELECT FIRST "sitename" FROM "vacancy" WHERE "vacancyid" = @VacancyID);
  RETURN "rv"
END
}