Thanks Jim that is indeed true.
Simon
>My guess is that you are operating with DELETED ON and do not have a TAG on DELETED().
>
>The usual warning applies - "partial" may be better in THIS case.
>
>
>>Hi
>>
>>I have a table indexed on PID+DToS(Date) and when I issue the following query it reports that it is only partially optimized.
>>
>>Select * From myTable Where PID+DToS(Date)="!!!!!#"
>>
>>I expected it to report that is was fully optimized. Can someone explain why it is only partially optimized?
>>
>>It also reports partial optimization when I add the date as follows:
>>
>>Select * From myTable Where PID+DToS(Date)="!!!!!#20021225"
>>
>>Thanks
>>Simon
Simon White
dCipher Computing