Re: case insensitive LIKE and addLike vs addSQL

Hi Thomas,

Geike, Thomas wrote:
> Hi all,
>  
> I am having trouble to generate case insensitive LIKE sql clauses with
> ojb.
>  
> The SQL I want to produce in the end should look something like this:
> SELECT * FROM <table> WHERE UPPER(<column>) LIKE UPPER(<user_input>);
....
> Does anyone know a solution to this problem?
> Any help appreciated. Thanks a lot in advance.

Sorry no. Currently OJB doesn't analyze query parameter values (e.g. 
"LIKE UPPER(<user_input>)") for sql-functions.
By the way, is it allowed to use function expressions as parameter value 
in a PreparedStatement?

regards,
Armin