Hi,
I am looking generate code that will produce sql like:
[name] NOT like 'P%'
I do use CustomerFields.Name % "P%" to generate:
[name] like 'P%'
but is there a reversal operator to go with or replace the '%'?
Ron.
var p = Functions.Not(CustomerFields.CompanyName.StartsWith("P");
or
var p = Functions.Not(CustomerFields.CompanyName.Like("P%");
You have to include the namespace SD.LLBLGen.Pro.QuerySpec
Or
var p = CustomerFields.CompanyName % "P%"; p.Negate=true;