>Recently, I always skip all possible cases on using memo datatype as I donno how to handle it well.
>
>Now, I have time and want to try the basic function related to memo.
>Could you give some related functions/samples on memo field?!
>
>I want to know how to compare two memo field content!?
>including finding same or different in detail..
>How to do so!?
>
>Thanks for guide
Justok,
Exactly the same way you do it for character fields.
Memo1 = memo2 && will tell if two memos are the same
Text $ Memo && Tells you if Text is contained within memo
LEFT(Memo,50) && returns the first 50 characters from the memo
You can use any character function on a memo field.