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