Tech Tip: Using wildcards with QUERY BY SQL
PRODUCT: 4D | VERSION: 14.1 | PLATFORM: Mac & Win
Published On: November 26, 2014
In order to to use the "%" wildcard in a SQL query, a "LIKE" SQL verb must be used. Here is an example of using the wildcard with QUERY BY SQL command:
| C_TEXT($sqlFormula) $sqlFormula:="First_Name LIKE 'v%'" QUERY BY SQL([Table_1];$sqlFormula) |
See Also: