====== pears.CollectionHeadline ======
<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"."CollectionHeadline"( 
  in @CollectionID char(20) ) 
returns long varchar
begin
  declare "rv" double;
  -- if has no parent then top level
  -- if a parent look at children??
  return "rv"
end
</code>