pears.CompanyKeyWordsQuestion

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original 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
}