Regarding JDataStore DataBase

[srinath jeyanthi]

please help me any body my question is,
i am using my java project JDataStore as backend .it is platform
independent.In this database does not support IN operator while i am updating four different records that i given IN operator where clause.And also won't support substr function also.plese give the alternate solution for this situation.
query:
update emp set job='manager' where empno in(10,20,30);
this query is not working our JDataStore DataBase.
thanks
regards,
jeyanthi.

[Thomas Paul]

IN merely is a short form of or =
Try this:

update emp set job='manager' where
empno = 10 or
empno = 20 or
empno = 30