Hi Junilu, Could you explain further, I didn't understand what is the interger type of column type. I mean if it is string what it should return, if it is 'Date' type what should this method return. Thanks Neha
Ivor Horton's chapter of his Beginning Java book, on JDBC is on the web, I think at the Sun site. He explains this very well. It's in PDF, or I would paste an excerpt here. "The Types class in the java.sql package defines public fields of type int that identify the SQL types, and the names of these class data memebers are the same as the SQL types they represent -- such as CHAR,VARCHAR, DOUBLE..."