To Find

Type this in the field

Examples

Words that start with Roman characters

The characters

Chris Smith finds Chris Smith, Smith Chris, Chris Smithson, and Smith Christenson

Words with one or more unknown or variable characters

One wildcard character (@) for each unknown character

Gr@y finds Gray and Grey

@on finds Don and Ron but not Bron

Invalid characters in a text field

“?”

Invalid characters display as blank characters

Note:  To find the ? character, search for "?"

Digits in a text field

A # character for each digit

# finds 3 but not 30

## finds 30 but not 3 or 300

#3 finds 53 and 43 but not 3

Words with zero or more unknown or variable text characters in a row

* for all unknown characters

Jo*n finds Jon and John

J*r finds Jr. and Junior

*phan* finds Stephanie, Stephan

Exact matches of the text you specify

== (two equal signs)

==John finds John but not Johnny

A date in a date field or in a calculation field that produces a date result

The date as digits, separated by a valid date separator character (such as a slash or hyphen)

3/3/2003 finds 3/3/2003, March 3, 2003, and 3-3-2003

Today's date in a date field or in a calculation field that produces a date result

//

// finds April 4, 2004 (when the current date is 4/4/2004)