? (Wildcard)

Search for answers or browse our knowledge base.

< All Topics
Print

Matches all subsequent characters in a value.

Syntax

expression1 = expression2 ?

Parameters

expression1A character string, or a variable or form field that evaluates to a character string.
expression2A character string, or a variable or form field that evaluates to a character string.

Comments

Used with the equals sign in logic expressions, the ? wildcard matches any number of subsequent characters when expression2 is compared to expression1. The question mark must appear outside of the pattern string.

Example

DeptNum = "D56"?

Logically true if the department number begins with the string “D56”. Notice that the question mark must appear outside the string.

RemarkField = "Smith?"

Shows the question mark being used literally in a string. (The characters appear inside the quotation marks.) The expression is logically true only if Remarkfield contains the exact characters Smith?.

Surname = fCustomer.LastName?

Shows how the wildcard can be attached directly to an atomic expression employing a variable, local variable, form field, or formal parameter, provided the object is of a character data type. (Trailing blanks in the specified object are trimmed for pattern-matching purposes.)

See Also

Conventions

How To Construct Logic Expressions

How To Use Logic Expressions

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish