Hi,

we would build a Fulltext Query like: select * from tbl500 where contains((C001,C002,C003) , 'TEST') or better select * from tbl500 where contains(* , 'TEST')

we use currently the Predicate-Syntax: FieldFullTextSearchPredicate(EntityField.C001....) or FieldFullTextSearchPredicate(EntityField.C002....)...

thats outcom with low performance. IS there another way?

Many Thanks Markus

That's supported since v2.5, you can specify multiple fields in the FieldCompareFullTextSearch predicate. (for sqlserver2005 and up).

public FieldFullTextSearchPredicate(IList entityFields, FullTextSearchOperator operatorToUse, string pattern)