Case Insensitive query option

[Bejoy Zac]

Hi All,

While fectching the data is there any way to ignore the case?

[jonwimp]

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?