As you have posted this question in the
JDBC section, I suppose that you are retrieving this values to be displayed in some
JSP or in any
Java file as a form of output.
So, wht I have in mind is, while retriving these values from the DB thru the resultset, you can concatenate them while placing them in the bean like:
someBean.setSisRec(rs.getString(COL_NAME1)+" " + rs.getString(COL_NAME2)+" " +rs.getString(COL_NAME3));
This would set the concatenated form of the values from the DB into the bean on which you can perform any more functionality related implementation.
Hope this helps!!