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 (>) |
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. |