I'm having a hard time figuring out how to use the LIKE operator in LLBLGEN. Suppose I have a SELECT statement like the following:

SELECT * FROM Events WHERE EventDescription like '%Tuesday%'

How would this look in self-servicing code?

Thanks much.

Laurie

The filter should look like the following:

PredicateExpression filter = new PredicateExpression();
filter.Add(EventsFields.EventDescription % "%Tuesday%");

Okay, then how would it look if the keyword you were searching for were a variable, e.g. instead of the word "Tuesday" you had the string strDayOfWeek?

larkydoo wrote:

Okay, then how would it look if the keyword you were searching for were a variable, e.g. instead of the word "Tuesday" you had the string strDayOfWeek?

'in VB
Dim pe as New PredicateExpression()
Dim search as String = "%" & strDayOfWeek & "%"
'.NET 2.0
pe.Add(EventsFields.EventDescription Mod search)
'alternately
pe.Add( New FieldLikePredicate(EventsFields.EventDescription, search))

hope this helps

-Micah

Works great! Thanks!