Enhancement
A pattern match can be performed in SQL. Ex:
select * from "table" where "col" like '%test%'
This finds all rows in which the column value for "col" contains the substring "test".
The TopLogic SQL language should support this.
Test
TestCompiledStatement