Escaping within the WHERE clause

This example shows how to escape to 1010data Macro Language code in a WHERE clause.

Examine the following query:
SELECT * FROM pub.demo.weather.stations
          WHERE {sm(name;'S*')|sm(name;'A*')&sm(name;'*E')};
This query returns 9 rows, namely those stations whose name begins with either S or A, and end with E.