or... select count(volume_name) FROM LIBVolumes where libvolumes.status='Scratch'
-----Original Message----- From: Lawrence Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 7:28 AM To: [EMAIL PROTECTED] Subject: Re: How many scratch volumes in library? "SELECT LIBVOLUMES.VOLUME_NAME,LIBVOLUMES.STATUS FROM LIBV OLUMES WHERE LIBVOLUMES.STATUS = 'Scratch'" >>> [EMAIL PROTECTED] 10/17/01 06:19PM >>> How can I find out quickly how many scratch volumes I have in my library? Thanks ***************************EMAIL DISCLAIMER************************** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
