====== pears.VacancyKeyWordsQuestion ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."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" as "t"
    where "t"."TagLocation" like 'V%' and "t"."IncludeInKeyWordSearch" = 1 and "t"."TagType" in( 'T','U','L','M' ) ;
  return "rv"
end
</code>