Using Special Characters in Global Search

 

Global Search supports the following special characters when searching historical and static data in Sage 100.

 

Special Character

Definition

& ampersand
' apostrophe
* asterisk
\ backslash
{ } braces
^ caret
: colon
/ forward slash
- hyphen
+ plus sign
| pipe
( ) parentheses
? question mark
~ tilde

 

 

Tips For best search results, we recommend:

  • Adding a backslash (\) before a supported special character in the Search field
  • Performing a search on more than one character (exception: miscellaneous items)

Examples of searches with special characters

 

The following table shows examples of using special characters in Global Search with Sage 100 demo data.

To search for the following data in Sage 100.... Enter the following in the Search field....

Customers with phone numbers in (714) area code

\(714\)

Customers with phone numbers in +52 country code \+52
Customer name with an apostrophe (') Allen\'s
Miscellaneous items

\/

Note This entry is a backslash (\) followed by forward slash (/).

Item codes starting with 586/ 586\/
Purchase order receipts for vendor number J&J J\&J