This works for me...

select volume_name, -
  pct_reclaim, -
  stgpool_name -
from volumes -
where pct_reclaim>=60 -
order by 3,2 asc

Shelby

>Does anybody know  how to get from an select command the list of volumes
>with more than 60 percent reclaimable space ....

>T.I.A  Robert


>***************************************************************** * Ouzen
>Robert             E-mail: robert AT research.haifa.ac DOT il  * * Helpdesk
>Manager         Phone:  (972)-4-8240345              * * Computer Center
>Fax:    (972)-4-8342097              *
>* University of Haifa              (972)-4-8249177              * * Mt.
>Carmel, Haifa 31905 Israel                                *
>*****************************************************************


--
If you had your life to live over
If you had your life to live over
again, you'd need more money !
-----------------------------------------------------------
Shelby Lynne Beach
Shelby Lynne Beach
Teale Data Center
2005 Evergreen Street
Sacramento, CA 95815

(916) 263-6079
-----------------------------------------------------------
=========================================================================