Checking text responses
With text questions you can test whether the response matches, or is like, a pattern.
Syntax
Qname Like "pattern"
Parameter
pattern
The text with which the response is to be compared. An underscore in the text matches any single character, and a percent sign matches any number of characters, including zero.
Example
A telephone service provider may be about to install a special high-speed internet access service on a local exchange, and may want to ask respondents whose numbers belong to that exchange whether they would be interested in using the service. If the Metadata contains a text question called TelephoneNumber, you could test for respondents in the 01342 area using the expression:
TelephoneNumber like "01342%"
This expression returns True for all respondents who typed telephone numbers starting with 01342.
The = and <> operators are valid with text responses but are only useful for short responses where you know what the responses are likely to be.
See also