Hi Robert You can use
select * from libvolumes where library_name='SCALAR' and status='Private' and last_use is blank Kaj -----Original Message----- From: Robert Ouzen [mailto:[EMAIL PROTECTED]] Sent: 30. januar 2003 08:54 To: [EMAIL PROTECTED] Subject: Help on Select command 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:[EMAIL PROTECTED]