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 (*)
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.
Question mark (?)
A wildcard character. Represents any character or characters. 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.