The SQL language provides powerful search capabilities. FairCom DB SQL provides the LIKE clause for some field types, however, the LIKE predicate clause does not allow searching LONG fields, such as LVARCHAR.
To extend advanced searching for LVARCHAR fields, FairCom DB SQL now provides CONTAINS, as an available search condition predicate.