>>Valentina 2.0 now can do searches on NON-indexed fields. >>So to really build index, you need explicitly say: fIndexed. >> I've been looking at the SQL docs but don't see an obvious answer to this question: what is the SQL way to search an *unindexed* text field for a 1. word begining with "aaa" and a 2. word "aaa" without using REGEX? Thanks, Jon