Hi All, Is this valid. I am unable to use UPPER function in EJB QL. Is there any other method of writing the query. The value of "?" can be uppercase or lowercase, I have to get the whole data for it. How can I do that.
<ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM Employee o WHERE (UPPER(name) LIKE ?1))]]></ejb-ql> thanks Prasad. =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
