Hi to all

I try to figure the correct select syntax to get the volumes from a library
where the status is Private and the last use is empty:

I run:

select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use=' '

and got: ANR2034E SELECT: No match found using this criteria.

But in fact I had some volumes ....

Any help will be appreciate.
Regards Robert Ouzen
E-mail:rouzen AT univ.haifa.ac DOT il