I want to do a search on my Members table. It's possible a person might search for "last name, first name" , so I need in a filter "where lastname & ", " & firstname = " & keyword

I need to check against two combined fields with a string against my keyword.

any ideas?

Hi there,

If you are using SQLServer and LLBLGen v2.5+ you could do that this way (assuming Adapter TemplateSet and C#):

// collection to fetch
EntityCollection<CustomersEntity> customers = new EntityCollection<CustomersEntity>(new CustomersEntityFactory());

// filter
IRelationPredicateBucket filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(CustomersFields.FirstName.SetExpression(CustomersFields.LatName + ", " + CustomersFields.FirstName) == "Ana Trujillo, Owner");

// fetch results
using (DataAccessAdapter adapter = new DataAccessAdapter())
{
    adapter.FetchEntityCollection(customers, filter);
}

If that doesn't work for you, please post some relevant information