Hi Stefan,
you can try this: myCriteria.addEqualTo("UPPER(meinStringField)", "mytext"
);
Works at least for DB2.
Regards
Lasse
|---------+----------------------------->
| | Stefan Schl�sser |
| | <[EMAIL PROTECTED]|
| | mediate.de> |
| | |
| | 19.02.04 13:51 |
| | Bitte antworten an|
| | "OJB Users List" |
| | |
|---------+----------------------------->
>-------------------------------------------------------------------------------------------------------------------------------|
|
|
| An: OJB Users List <[EMAIL PROTECTED]>
|
| Kopie:
|
| Thema: How to do a not casesensitive string equal Criteria ?
|
>-------------------------------------------------------------------------------------------------------------------------------|
Hi,
I'd like to formulate a Criteria
crit.addEqualTo("meinStringField", "mytext");
which should match MYTEXT, mytext, MyText etc. i.e. a incasesensitive
match.
How do I do that using ojb (without resorting to tablecolumn names or
straight sql) ?
By the way, I am using SAPDB and HSQL
Thanks for your help,
Stefan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
