This question might be better posted in the JDBC forum, where SQL questions tend to get asked. You are more likely to get a response.
That being said:
My question is is it possible to use LIKE keyword for the columns which contain int?
No (unless the emp_number column is a character data type). The LIKE operator is for character, string or clob values, not numeric values. What is "like" 3 anyway? Values near it e.g. 2 and 4? Or values including a 3 e.g 33, 333, 1903, 0.23232?
You could change Emp_number to a varchar datatype, or use a BETWEEN or IN operator, if either of those suit what you are trying to acheive. [ May 16, 2005: Message edited by: Paul Sturrock ]