1 Only if conversion from text to numeric is possible.

2 Operation occurs on the date's double value representation. If the operation involves an invalid date, '####' is returned.

3 Only if conversion from text to long or categorical is possible.

4 Only if conversion from text to date is possible.

5 If the text can be converted to a long without loss of precision, the result is a long.

The visits12 and visits variables are numeric (Long) variables that record the number of visits that respondents have made to the museum in the previous 12 months and prior to that, respectively. The expression adds the values in the two variables and compares whether the result is greater than 3. For example, you could use this expression to create a filter to select respondents who have made a total of more than three previous visits to the museum.

The remember and interest variables are categorical variables that have similar category lists. The + operator performs a union of the two category lists and the >= operator tests whether the combined category list that results contains the Dinosaurs category. This means that you could use this expression to select respondents who chose the Dinosaurs category in response to either or both of the questions on which the variables are based.

The name and address variables are text variables. This example uses two + operators to concatenate three text strings to form a single string containing the respondent's name and address separated by a colon and a space. For example, you could use this expression to create a “name and address” derived variable.

The above example shows how to use the operator in mrScriptBasic or mrScriptMetadata. In an SQL query, enclose the text string in ' ' (single quotation marks) and not " " (double quotation marks), like this: