>Howard,
>
>>Master Index tag: PAGERNAME Collate: Machine Key: UPPER(PAGERNAME)
>>I've tried removing UPPER() from the index key but no joy.
>
>this should not happen - are able to put a sample of the table and the cdx on a server somewhere ?
>Others might look at it directly. If it is sensitive data, make a copy and replace with cleaned data, but make sure you still see the problems you describe.
>
>my 0.02 EUR
I think it may help to select all data into a separate table, zap the original table, reindex it and then append from that table.
>
>thomas
If it's not broken, fix it until it is.
My Blog