Hello All,

i know about FieldLikePredicate, but i want following query in llbl

SELECT * FROM dbo.Holiday WHERE Holiday NOT LIKE '%New%'

how can i do this?

The FieldLikePredicate has a negate property. ref: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=15891 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5837