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.
posted 15 years ago
IN merely is a short form of or = Try this:
update emp set job='manager' where empno = 10 or empno = 20 or empno = 30