Re: Is it platform independant if I use upper() and like '%'?

[Jakob Braeuchi]

hi zhe,

upper is not platform independent. i'm not sure about the '%' most dbms accept 
it but ms-access uses '*' .

jakob

ZZZ Liu wrote:

Hi All,

I am using ojb as the persistence layer and assume
that I don't need to re-write my code if I need to
switch to a different database. However, if I use 

Criteria crit = new Criteria();
crit.addEqualTo("upper(firstname)", "TOM");
crit.addLike("firstname", "T%");
Is it still platform independant?

Thanks in advance for you reply.

Zhe

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]