Hello

I'm trying to create a search bucket for the following script:

select * from p inner join q on p.ColumnID like convert(varchar(2), q.ColumnID ) +'%'

Problem here is I dont know how to create join condition with like operator! thanks!

use the percent symbol (modulo?) for a sort hand like opeator.

fitler.PredicateExpression.Add(myField.FieldName % "myValue" + "%");

To make a Join, you should add an define and use an EntityRelation (added to the relationPredicateBucket relations collection, if you are using a RelationPredicatebucket).

To have a filter beside the ON Clause, assign the filter to the CustomFilter property of the EntityRelation. If you want to use this filter instead of the ON Clause set the CustomFilterReplacesOnClause property to true.

I Used CustomFilter and CustomFilterReplacesOnClause property But problem is that I cant make a PredicateExpression To compare two Field of diffrentTables with Like operator!

You can implement your own IExpression and use it instead: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829