select dpt_no concat dpt_nam from db2admin.bsdptms oracle select dpt_no||dpt_nam from db2admin.bsdptms select concat(dpt_no,dpt_nam) from db2admin.bsdptms informix select dpt_no||dpt_nam from db2admin.bsdptms sybase select dpt_no||dpt_nam from db2admin.bsdptms access select dpt_no+dpt_nam from db2admin.bsdptms foxpro select dpt_no+dpt_nam from db2admin.bsdptms sqlserver select dpt_no||dpt_nam from db2admin.bsdptms
