Hi, How can I do a case insenstive comparison using the FieldCompareRangePredicate which results in the 'in' clause in the sql query.

For example with other predicates (e.g. FieldLikePredicate) I can use the CaseSensitiveCollation = true option but cant do that with FieldCompareRangePredicate.

I am using LLBLGen Pro 2.6 Final and Adapter and C#. Oracle back end database (11g) with Oracle drivers.

Thank you.

How would you write this in SQL for Oracle?

Something like the following: (I am at home at present so do not have access to my work development computer)

Basic query:

SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...)

One way: (using the upper function)

SELECT column_name(s) FROM table_name WHERE upper(column_name) IN (value1,value2,...)

Another way:

SELECT column_name(s) FROM table_name WHERE upper(column_name) IN (upper(value1), upper(value2),...)

I am off to watch the Olympic opening ceremony!

This is a way to do that:

var values = new List<string>() { "alfki", "bRpd", "ZPICA" };

var filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(
    OrderFields.CustomerId.SetExpression(
        new DbFunctionCall("UPPER", new object[] {OrderFields.CustomerId})) 
    == values.Select(val => val.ToUpper()).ToList());

Krish wrote:

I am off to watch the Olympic opening ceremony!

Thank you very much, looks pretty cool. I will try this out on Monday and post again.

Like the London Olympics works like a charm. Thank you very much.