Using special characters in a filter
If a filter expression contains one or more of the following special characters, a backslash (\) must precede each special character.
*Ampersand (&)
*Hyphen (-)
*Asterisk (*)
*Less than sign (<)
*Backslash (\)
*Number sign (#)
*Close square bracket ( ] )
*Open square bracket ( [ )
*Comma ( , )
*Pipe sign (|)
*Equal sign (=)
*Question mark (?)
*Exclamation point (!)
*Single quotation mark ( ' )
*Greater than sign (>)
 
For example, to search for a document named Newsfeeds#1, type the following search expression:
newsfeeds\#1
Using operators in a filter
The special characters described in Table 2‑1 are also operators in a filter or search expression.
Table 2‑1 Description of filter operators
Operator
Description
Asterisk (*) or question mark (?)
A wildcard character. Represents any character or characters.
Greater than sign (>)
Precede the first character of a search string with the greater than sign to return all rows in which the first n characters of the name has a value greater than the first n characters of the search string.
Greater than or equal to sign (>=)
Precede the first character of a search string with the greater than or equal sign to return all rows in which the first n characters of the name has a value greater than or equal to the first n characters of the search string.
Less than sign (<)
Precede the first character of a search string with the less than sign to return all rows in which the first n characters of the name has a value less than the first n characters of the search string.
Less than or equal to sign (<=)
Precede the first character of a search string with the less than or equal sign to return all rows in which the first n characters of the name has a value less than or equal to the first n characters of the search string.
Number sign (#)
Represents any single digit. If you type newsfeeds#, the search returns list item names that begin with newsfeeds and end with a number, such as newsfeeds1, newsfeeds2, for example.