>I have to store a string that is 1024 bytes (1K) in size. I would love it store them in a table and index them, but the only way I can think to do this is store the string in chunks of 254 bytes. Then I would have to put them back together in order to get the orginal string. Plus I have a problem creating that long of index.
>
>I know I can store them in memo fields, but those do no tend real well to indexing. I thought about memo binary, but the same problem. I thought about general, but ran into same types of issues. I know I can store a pointer to a text file and read them out of there, but no real way to index these.
>
>Does anyone have an idea I am overlooking? Is there a better way of storing and indexing these strings?
>
>Thanks,
>Dale
Dale,
When I first read your message, storing it in a memo + only the checksum in an indexed field came to mind. I see that Fabio already said that. Please read his message carefully.
PS: A key length is max 240 if collating is machine (otherwise half).
Cetin