pears.KeyWordSearchAllowed

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"."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
}