Dave Grainger
03-07-2002, 04:35 AM
Comparison operators and wildcards don't seem to work in ServerFilterByForm in my ADP. Is there a way to use them in ServerFilterByForm?
|
View Full Version : ServerFilterByForm Operators Dave Grainger 03-07-2002, 04:35 AM Comparison operators and wildcards don't seem to work in ServerFilterByForm in my ADP. Is there a way to use them in ServerFilterByForm? ozinm 10-28-2005, 04:10 AM % 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. |