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

     Another example is as follows:

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