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