Variables hold expressions, not values. SET assigns an expression to a named variable, but that expression is not resolved to an actual value until it is evaluated, each time it is evaluated.

You can resolve a variable’s value directly in another xSQL or xCL expression, or explicitly with the EVAL command.

To resolve a variable only once, in advance, see Evaluate Variable Expression Once.

NOTE: A variable’s result set can have multiple columns and rows, as we’ll see in the following examples.