escaping a character in a like expression

Posts   
 
    
mdissel
User
Posts: 92
Joined: 16-Sep-2003
# Posted on: 07-Sep-2007 11:26:29   

Hello

How can i construct this sqlquery with llblgen?

select ID from Tabel where content like '%@[%@]%' escape '@' 

Thanks

Marco

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 07-Sep-2007 16:11:13   

You may inherit from FieldLikePredicate. And override the ToQueryText() to generate the SQL that you want.

Hint: Have a look at FieldLikePredicate.cs in the LLBLGen Pro source code.