pears.KeyWordSearchAllowed

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."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