How to create Index for a Memo field??

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

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)