ServerFilterByForm Operators

  • Thread starter Thread starter Dave Grainger
  • Start date Start date
D

Dave Grainger

Guest
Comparison operators and wildcards don't seem to work in ServerFilterByForm in my ADP. Is there a way to use them in ServerFilterByForm?
 
%
Any string of zero or more characters.
LIKE '%computer%' finds all book titles with the word 'computer' anywhere in the book title.

_ (underscore)
Any single character.
LIKE '_ean' finds all four-letter names that end with ean (Dean, Sean, and so on).

[ ]
Any single character within the specified range ([a-f]) or set ([abcdef]).
LIKE '[C-P]arsen' finds names ending with arsen and beginning with any single character between C and P, for example Carsen, Larsen, Karsen, and so on.

[^]
Any single character not within the specified range ([^a-f]) or set ([^abcdef]).
LIKE 'de[^l]%' all names beginning with de and where the following letter is not l.
 

Users who are viewing this thread

Back
Top Bottom