>Hi Alan,
>
>--------
>Try this. Right after 'CLEAR', add the following line:
>
>Set Collate to "General"
>You can reset to 'Machine' or whatever afterward.
>
>Sorry Alan, but it is absurd to use a binary index with a collate different to MACHINE.
>

Well, maybe, but if you want to use binary data in your table, it seems to me that using a binary index might not be so absurd.

Otherwise, it gets even worse. Leave out the line to set collate to "General", and at the end of your code, add:

Select test
Browse

Then, when you close the query browse and the Test browse opens, select the second record. Close the browse, and then type 'browse' in the command window to reopen it. It's a mess.

Alan

>

>SET COLLATE TO "General"
>? CHR(1)=CHR(0)
>? CHR(6)=CHR(1)
>

>
>Fabio