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