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