====== pears.BlobstoreFullPath ======
<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"."BlobstoreFullPath"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "xpath" char(250) ) 
returns char(250)
not deterministic
begin
  /* if xpath is relative then prepend with the database folder */
  if "charindex"(':',"xpath") > 0 or "left"("xpath",1) = '/' or "left"("xpath",1) = '\\' then
    return "xpath"
  else
    return "BlobstoreDbFolder"()+"xpath"
  end if
end
</code>