>How can I search in a memo field for a certain expression. The expression is "Please Reply To Email Address" and what I wanting to do is get this email address. What I have notice if there is an e-mail address it's always the last line in the memo field. Any ideals how I can do this.
>
>Thanks Randy
Something like
SELECT * FROM mytable ;
WHERE "Please Reply To Email Address" $ mymemofield ;
INTO CURSOR crsTemp
DIME laList[1]
SCAN
ALINES(laList, mymemofield)
lcEmailAddres = laList[ ALEN(laList)]
ENDSCAN
--sb--