There's no problem with LIKE anyvalue, and you can even use the LOWER function to catch both C and c like this:
SELECT Sales.RefNumber,Sales.BillAddressAddr1,Sales.Type,Sales.TxnDate FROM Sales WHERE Sales.BillAddressAddr1 = 'Customer Name' AND Sales.TxnDate <= {d '2006-04-09'} AND {fn LCASE(Sales.Type)} LIKE 'c%' ORDER BY RefNumber
Tthe following query shows how a like "i%" works to find "Invoice" type sales:
SELECT Sales.RefNumber,Sales.BillAddressAddr1,Sales.Type,Sales.TxnDate FROM Sales where {fn LCASE(Sales.Type)} LIKE 'i%' ORDER BY RefNumber
|