Hi,

I've got a simple problem which I'm sure there's going to be an easy fix but can't seem to find it anywhere.

I need to search the DB using an SQL like rather than equivelance:

For example any standard search is performed as:

filter.AddWithAnd(TradeFields.Name == Type);

But I need a:

filter.AddWithAnd(TradeFields.Name Like Type);

Simple (surely!?)

Many thanks in advance,

Brett

filter.AddWithAnd(TradeFields.Name % Type);

Simple!

Many thanks,

Brett