[OJB-developers] Case insensitive search criteria

[Andrew P. <api...@op...>]

Howdy,  

I have a need to implement case insensitive queries.  In my application,
I need to store certain names in a case sensitive fashion, but need to
validate them ignoring case (I really don't want to store a second
lowercase version of the field).

In searching I figured I could use criteria.addSqlCriteria(..) but I
really really want to use field names and not table columns.

Before I go and try to implement a CaseInsensitiveFieldCriteria, is
there a better way to go??

Thanks and cheers
Andrew