Knowledgebase: Syntax
[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 QueryNote: There's no problem with LIKE anyvalue. Here we are running the following query as an example to show how a like "i%" works to find "Invoice" type sales: SELECT Sales.RefNumber,Sales.BillAddressAddr1,Sales.Type,Sales.TxnDate FROM Sales Another example is as follow: SELECT Name, CompanyName FROM Vendor Where Name LIKE 'Bay%' | |
|
Comments (1)
Alvin
20 September 2012 07:41 AM
That's an intelligent answer to a difficult qesution xxx