Finding text and characters
You can search for text in fields of type text, or in calculation fields that return a text result.
Unless you search for phrases or an exact match, the field can contain other values in addition to the one(s) you specify, and the values can be in any order. For example, typing hotel in a field named Accommodation finds records for Hotel, Discount Hotel, and Hotels, Luxury.
To find text and characters:
See Making a find request.
Chris Smith finds Chris Smith, Smith Chris, Chris Smithson, and Smith Christenson
"Marten and Jones Interiors" finds Marten and Jones Interiors but not Jones and Marten Interiors
", Ltd." finds all companies with ", Ltd." in the name, but not those without the comma
“Spring” finds Springville but not ColdSpring Harbor or HotSpring
One wildcard character (@) for each unknown character
Gr@y finds Gray and Grey
@on finds Don and Ron but not Bron
Note  To find the ? character, search for "?"
# finds 3 but not 30
## finds 30 but not 3 or 300
#3 finds 53 and 43 but not 3
* for all unknown characters
Jo*n finds Jon and John
J*r finds Jr. and Junior
*phan* finds Phan and Stephanie
S* finds Sophie, Steve, and Sven
"@" finds @ (or an email address, for example)
"," finds records containing a comma
"   " finds three spaces in a row
\"Joey\" finds "Joey"
joey\ finds the email address
"òpera" finds òpera but not opera
(òpera without quotation marks finds both òpera and opera)
Characters, punctuation, and spaces between double quotation marks ("); use * to find this text in the middle of a longer text string
Johnson & Phillips and Paulson & Phillips
==John finds John but not John Smith
==John Smith finds John Smith but not Smith, John or John Smithers
=Market finds Market, Market Services, and Ongoing Market Research but not Marketing or Supermarket
=Chris =Smith finds Chris Smith or Smith Chris but not Chris or Christopher Smithson
~ (tilde) and the character, to do a relaxed search
When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
A find for fred finds Fred and FRED.
You can perform case-sensitive and width-sensitive finds on a field by changing the default indexing and sorting language for the field to Unicode. However, this procedure will change the order in which the field sorts. If you do not want the original field to sort in Unicode order, create a calculation field whose formula is simply the field in which you want to perform case-sensitive or width-sensitive finds, and change the default indexing and sorting language of this field to Unicode. Then you can sort one of the fields, and perform find requests on the other. See Defining field indexing options and Defining calculation fields.
Related topics 
Finding duplicate values
Finding ranges of information
Choosing a language for indexing or sorting