Well first of all, the LIKE operation in all the RDBMS that I am familiar with is not very applicable to numeric columns within the tables.
user_id LIKE '%00'
Where user_id is an INTEGER column will NOT match, say the number 100. This is because the database does not treat numeric columns like strings, and therefore a wildcard comparison based on a string is useless. Oracle DOES let you use the LIKE comparison operator against numerical fields without error, but you will find yourself getting empty result sets.
Originally posted by VIKU:
Hi David,
If you will see
ps.setInt(1,"%00"+refreshTime);
then "%00"+refreshTime is a String and setInt is defined as
setInt(int,int) but here it will be setInt(int,String).
Hope you got.
Any more suggestion.
Thanks
Vivek