>Boris,
>
>>Char fields can be used in INDEX (memo also but with some transformation).
>
>Just wanted to add that this is somehow incorrect, as you can only index if the length of the character field is 240 or less, otherwise you are in the same situation as with Memo. Also if you are not using CDX but IDX, then the limit is 100 chars.

And half that in any collating sequence except Machine, because they use 2 bytes per character to store sequencing equivalent string.