You can also concatenate with the '||' operator, like this: select filespace_name || hl_name || ll_name from backups ...
Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 05/21/2004 04:57 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: Select list of files backed up/archived on tsm?!? ... >select * from backups where node_name='CHSU050', but that doesn't give me >the actual name of the file, it just gives high level and low level. ... FILESPACE_NAME + HL_NAME + LL_NAME constitute the full path spec of the file. The Select is not withholding anything. You can do like select concat(HL_NAME, LL_NAME) from backups to stick those two components together. Richard Sims
