>>I would lke to search for a specified character string in a memo field, can I use a standard SEEK(), or do I need to use something else?
>
>Maybe it was a fluke, but I put an index expression UPPER(MEMO) on a table (30,000 records) and when I did:
>
>SELECT * FROM TABLE WHERE AnyString $ UPPER(MEMO)
>
>and it was returning everywhere from 15000 records to 0 all under .5 seconds.


How did you index a memo field? When I try I get "Invalid key length."