All, I'm looking for a select statement that will return only the first value found, even if multiple values match the query.
For example, if there are multiple DB backup tapes in a library, I want to do something along the lines of: select backup_series volume_name from volhistory where type like 'BACKUP%' and have it return only values with the first backup series found. I think I need to be using "coalesce", but any of the combinations I've tried don't quite get it. Any assistance appreciated.... -Lloyd