Benjoy, Simply capitalize (convert to upper case) both operands you're comparing.
Eg, ... WHERE UPPER(field) = UPPER(value) If you're using Java, you could do: new EntityFunction.UPPER(new EntityFieldValue(fieldName)) In Minilang, try <condition-expr>, attribute "ignore-case" true. Jonathon Bejoy Zac wrote:
Hi All, While fectching the data is there any way to ignore the case?
