I am using SQL Server 2000 to implement a database. My Java code needs to access elements of this database. However, I have a problem.

Each row contains say 8 columns. I may want to access column 1, then column 2 etc etc. However, I may want to access column 6, then column 7 then column 5. This is not allowed through the common Java ResultSet and Statement objects - does anyone know how to do it?

Thanks

HD