====== pears.CompanyKeyWordsQuestion ======
<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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."CompanyKeyWordsQuestion" IS 
{create function CompanyKeyWordsQuestion 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in @CompanyID char(20))
returns long varchar
begin
  declare rv long varchar;
  select list (distinct GetQuestAnswer(t.TagLocation, t.TagID, @CompanyID),' ') into rv 
     from Tag t 
     where t.TagLocation like 'C%' and t.IncludeInKeyWordSearch = 1 and t.TagType in ('T','U','L','M');
  return rv;
end
}
</code>