hi, i could not find a way i can use the equivalent of sql UPPER and LOWER in ejb query language. basically if i have a 'employee' table with column 'name' and 1 entry for Jack. if the user searches for 'jack' , i should return the row. but the finder-query does not allow me to use anything but the below: <finder-query>< ![CDATA[(like name $0)]]></finder-query> so unless i store the table data in lowercase or uppercase (which i don't want to), i cannot do a case-insensitive search. advise anyone?