If the LOCATION isn't set then it is NULL. So your select should look like: select * from volhistory where (type='BACKUPINCR' or type='BACKUPFULL') and location IS NULL
HTH Thomas Rupp -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Warren, Matthew (Retail) Gesendet: Mittwoch, 23. Februar 2005 11:49 An: ADSM-L@VM.MARIST.EDU Betreff: select query misbehaving? Hallo TSM'ers. Am I going mad, or shouldn't this actually work? tsm: CARSINGTON>select * from volhistory where (type='BACKUPINCR' or type='BACKUPFULL') DATE_TIME UNIQUE TYPE BACKUP_SERIES BACKUP_OPERATION VOLUME_SEQ DEVCLASS VOLUME_NAME LOCATION COMMAND ------------------ ----------- ------------------ ------------- ---------------- ---------- ------------------ ------------------ ------------------ ------------------ 2005-02-18 0 BACKUPFULL 1460 0 1 ULTRIUM2 SW0130 20:04:57.000000 2005-02-18 0 BACKUPFULL 1461 0 1 ULTRIUM2_PHNX 000043 21:00:26.000000 2005-02-19 0 BACKUPFULL 1462 0 1 ULTRIUM2 SW0111 20:04:29.000000 2005-02-19 0 BACKUPFULL 1463 0 1 ULTRIUM2_PHNX P20100 21:08:38.000000 2005-02-20 0 BACKUPFULL 1464 0 1 ULTRIUM2 S20225 20:03:40.000000 2005-02-20 0 BACKUPFULL 1465 0 1 ULTRIUM2_PHNX P20306 22:34:30.000000 2005-02-21 0 BACKUPFULL 1466 0 1 ULTRIUM2 S20411 20:03:45.000000 2005-02-21 0 BACKUPFULL 1467 0 1 ULTRIUM2_PHNX P20209 21:07:10.000000 2005-02-22 0 BACKUPFULL 1468 0 1 ULTRIUM2 SW0077 18:42:35.000000 2005-02-22 0 BACKUPFULL 1469 0 1 ULTRIUM2_PHNX 000020 20:26:48.000000 tsm: CARSINGTON>select * from volhistory where (type='BACKUPINCR' or type='BACKUPFULL') and location!='VAULT' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. tsm: CARSINGTON>select * from volhistory where (type='BACKUPINCR' or type='BACKUPFULL') and location not like '%VAULT%' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. Surely the last two should return the same as the first one in this case? _-'-_ -|- ___________________________ Disclaimer Notice __________________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432