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