How to create Index for a Memo field??

[Wesam]

Hi friends,

Can you help with my problem, I need to save text of more than 255 characters in my database and also I need to index it to speed up the search time, I can't use Text type field because it can contain 255 characters, hence Memo is the solution - but Memo fields cannot be indexed, so what to do ??

I appreciate your prompt answer,

Thank you in advance,

Wesam

[JHausmann]

You could have multiple 255 records that would contain the data. For example

Table1
Unique Identifier
Memo field


would be equivalent to


Table2
Unique Identifier
Sequence number
text(255)