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

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

( in SearchString Long varchar )
returns long varchar
begin
  if trim(SearchString) = '' then
      return 'Search string cannot be empty, please review criteria and search again'
  else if trim(replace(SearchString,'*','' ) ) = '' then
      return 'Cannot search on * alone, please review criteria and search again'
  else if ((searchstring like '%~%') or (searchstring like '%near%')) and (searchstring like '%"%') then
     return  'Cannot use " in full text proximity searches, please review criteria and search again'
  else return ; 
  end if end if end if;
end
}
</code>