HQL:
select obj from obj in class com.mvsc.czee.business.codes.jurisdiction.Country where (upper( obj.description) like ?

produces:
select obj.country_id as country_id, obj.country_cd as country_cd, obj.description_txt as descript3_ from RM_COUNTRY obj where ((upper(obj.description_txt)like ? )

I think the "like" needs a space in front, or it gives me a sql syntax error:

SQL0104N An unexpected token "END-OF-STATEMENT" was found following "ription_txt)like ? )

I've looked into fixing it but don't see a quick way to go about it. Any ideas?

Thanks,
Jenica

... opens 2 brackets and close only 1

I'll bet that's the problem! Thanks!!