Knowledgebase
[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 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
      where {fn LCASE(Sales.Type)}
LIKE 'i%' ORDER BY RefNumber

     Another example is as follow:

     SELECT Name, CompanyName FROM Vendor Where Name LIKE 'Bay%'

(242 vote(s))
Helpful
Not helpful

Comments (1)
Alvin
20 September 2012 07:41 AM
That's an intelligent answer to a difficult qesution xxx
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).