Cetin,

Do you have 5.0a. There was a bug in 5.0 with SET COLLATE TO GENERAL. I'm not sure if it applied to other collation sequences. It seems to me that this has to be a bug. The fact that _tally doesn't match what was returned by the query is very strange.

>Now, this would apply to whom that uses collate sequences.
>Config.fpw :
>codepage=1254 && Turkish windows
>collate=TURKISH
>
>-create a table
>-index on a field
>-enter some values to that indexed field ie: 5 records all "John Smith"

>select * from mytable ;
>  where myfield = "John Smith" &&Displays only one record
>? _tally   && Prints 0
>set collate to "MACHINE"
>select * from mytable ;
>  where myfield = "John Smith" &&Displays all
>? _tally   && Prints 5
>set collate to "TURKISH"
>* Same as above _tally = 0

So what could I be missing ????
>Cetin