Steve,


  Try this,
     select * from libvolumes where status='Scratch'
If you need to see only the volume names
     select volume_names, status from libvolumes where status='Scratch'


> -----Original Message-----
> From: Steve Hicks [SMTP:shicks AT KUB DOT ORG]
> Sent: Friday, February 23, 2001 11:13 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Query Scratch Volumes
>
>  What would the syntax be for a query to only show scratch volumes?