>Hi,...how can I search for a string in a memo field....eg I want to seach for a sentence and have a prg to seach thru the entire table's memofie for a particular sentence,...how can I do that,..would appreciate if you could assist...
>
You can use any of the string and substring compare functions such as LIKE() or the $ operator with a memo field. For example, to see if the string 'I like VFP' is in a memo field, you can
? 'I like VFP' $ memo field name. You can use this in SQL Selects and the like; you need to realize that this type of search is not Rushmore-optimizable, so with large tables it tends to be fairly slow.
If you have a need for faster searches, you might want to investigate third-party memo search tools like PHDbase. The search engine on UT is built using PHDbase.