Hi,

I am using LLBLGen Pro 3.1, Oracle 11i & SQL 2008.

How i can query to database with comparing uppercase of column.

e.g. select * from EMP where Upper(Emp_Name) = 'ABC'

Rishi

You should create a FieldLikePredicate with CaseSensitiveCollection=true. Example:

var likePredicate = new FieldLikePredicate(EmpFields.EmpName, null, theName.ToUpper());
likePredicate.CaseSensitiveCollation = true;

var filter = new RelationPredicateBucket();
filter.Add(likePredicate);

adapter.FetchEntityCollection(employees, filter);