1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

How can i use Not Like predicate with LLBL?

Posts   
 
    
diegoalonso
User
Posts: 14
Joined: 09-Sep-2007
# Posted on: 22-Jan-2008 14:04:12   

I need to use not like where clause like this:

Select * from Customer where not like 'abc%'

Do u know how can i do this?

Thanks a lot

jmeckley
User
Posts: 403
Joined: 05-Jul-2006
# Posted on: 22-Jan-2008 14:28:37   

either filter.Add(CustomerFields.CompanyName !% "Solution%"); or filter.Add(new FieldLikePredicate(CustomerFields.CompanyName, null, "Solution%", true));

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 23-Jan-2008 09:44:33   

Or 

filter.Add(!(CustomerFields.CompanyName % "Solution%"));

A lot of options simple_smile

ref: LLBLGen Pro manual's section Negative predicates Path: Using the generated code -> Adapter/SlefServicing -> Filtering and sorting -> Advanced filter usage