pears.VacancyKeyWordsQuestion

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."VacancyKeyWordsQuestion" IS 
{CREATE FUNCTION VacancyKeyWordsQuestion 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN @VacancyID CHAR(20))
RETURNS long VARCHAR
BEGIN
  DECLARE rv long VARCHAR;
  SELECT list (DISTINCT GetQuestAnswer(t.TagLocation, t.TagID, @VacancyID),' ') INTO rv 
     FROM Tag t 
     WHERE t.TagLocation LIKE 'V%' AND t.IncludeInKeyWordSearch = 1 AND t.TagType IN ('T','U','L','M');
  RETURN rv;
END
}