Re: EJB-QL trim usage

[Juan Pablo Lorandi]

Title: Message

You could just use CMP. As somebody has pointed, this is dependant on your app server, but a simple query would do. The app servers I work with allow me to use SQL instead of EQL for my queries. Of course, the SQL I provide changes as DB vendors do, but it'd still work without the need to resort to BMP.   Finally, you could use the LIKE function instead of trim; you'd also probably would need to sweep thru the results manually to check they satisfy the condition.   HTH,   JP =========================================================================== 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".