Article Writing

OriginalGriff wrote:

Simply the "Background" section and it's references to the company both of you work for caused me to raise it as "probable spam" in the reports forum in the first place

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

Nelek wrote:

There are no "both"

Quote:

The Value property will be rendered to a pattern by adding the % character at the beginning and the end of it:

VB.NET

Database.Table.Name = "Customers"
Database.Table.AliasName = "cust"
With Database.Table.Query.Items
   .Add("cust.CustomerId")
   .Add("cust.ContactName")
   .Add("cust.City", "Lon", QItem.Types.WHERE_LIKE)
End With

The generated SQL Statement will be:

SQL

SELECT cust.CustomerId,cust.CompanyName,cust.ContactName,cust.City _
FROM dbo.Customers cust WHERE cust.City LIKE N'%Lon%';