====== 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>
create function "pears"."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" as "t" join "Search" as "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" as "t"
      where "t"."taglocation" = 'P'
      and "t"."IncludeInKeyWordSearch" = 1
      and "t"."TagType" in( 'T','U','L','M' ) )),
    '') into "rv";
  return "rv"
end
</code>