====== pears.PersonKeyWordsQuestion ======
<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"."PersonKeyWordsQuestion" IS 
{create function PersonKeyWordsQuestion 

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

(in @PersonID char(20))
returns long varchar
begin
declare rv long varchar;
select nullif(trim( 
    (select list (GetQuestAnswer(t.TagLocation, t.TagID, @PersonID),' ') 
        from Tag t join [Search] s on (t.TagLocation = 'P' or  t.TagLocation = string('A',s.DepartmentID))  
        where 
            t.taglocation like 'A%' and 
            t.IncludeInKeyWordSearch = 1 and   
            t.TagType in ('T','U','L','M') and
            s.Personid = @PersonID )
    || ' ' || 
    (select list (GetQuestAnswer(t.TagLocation, t.TagID, @PersonID),' ')
        from Tag t
        where 
           t.taglocation = 'P' and 
            t.IncludeInKeyWordSearch = 1 and 
            t.TagType in ('T','U','L','M') )) 
    ,'') into rv; 
  return rv;
end
}
</code>