[QODBC-Desktop] How to use LIKE in query with QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
An Example of Using LIKE in Query
Note: There's no problem with the LIKE any value.
Here we are running the following query as an example to show how alike "i%" works to find "Invoice" type sales:
SELECT Sales.RefNumber, Sales.BillAddressAddr1,Sales.Type, Sales.TxnDate FROM Sales
Another example is as follows:
SELECT Name, CompanyName FROM Vendor Where Name LIKE 'Bay%'
20 September 2012 07:41 AM
That's an intelligent answer to a difficult qesution xxx