| stat | Index Level | sum |
| Syntax | |
| Category | Access |
| Type | Definition |
| Description |
uses the "[" and "]" characters to search for strings beginning with, ending with, or containing a given substring.
When used in conjunction with the "with" modifier, data elements may be searched for the occurrence of a string of characters, as illustrated in the examples. |
| Options | |
| See Also | wildcards |
| Example |
list invoices with name "[PICK]"
lists all invoices with the string "PICK" anywere in the name attribute. Any other string may proceed or follow the letters "PICK". Select invoices by name with name # "[PICK" selects a sorted list of invoice items whose name ends with the string "PICK". Any string of characters may precede "PICK", but the element must end with "PICK". list invoices with name # "value]" List those items whose name being searched "begins" with "value". Any string of characters may follow "value", but the element must begin with "value". "Wildcard" search. Used for searching for any characters within strings: select invoices with name = "[sm^th]" Retrieves any item containing at least five characters, the first two of which begin with "sm", followed by any character, and ending with "th". This retrieves "smith" as well as "smyth". list entity with name = "i^m" lists entity file items whose "name" attribute contains a string beginning with "i", followed by any character, and ending with "m". list entity with name = "a^^" list entity items whose Searches attribute for values containing a string beginning with "a" and followed by two characters. any two characters following the "a" will meet the selection criteria. Multiple selection criteria clauses: When applying multiple selections against a single attribute value, it is not necessary to build a separate selection criteria phase for each, as in the following examples: list customers with state = "ca" or with state = "az" or with state = "va" This could also be stated as: list customers with state "ca""az""va" |
| Warnings | The search process will match both upper and lower case occurrences unless the CASING ON statement is used. |
| Compatibility | D3 7.0 AP R83 |
| stat | Index Level | sum |