Multi-value Variables

A string variable with multiple values becomes a parenthetical comma-separated list when used as a SQL parameter, so that any of the values match with the Metamorph like operator. For example, the following query:

The capitals are:
<$states = "AL" "MS" "GA" "FL">
<SQL "select capital from State where state like $states">
  $capital
</SQL>

would match any of the given states, because the $states parameter becomes ``(AL,MS,GA,FL)''.