>Hello everyone,
>
>How can I search in the MEMO field a word or combined word like :
>Visual+Foxpro and will display every records in the table that have
>Visual Foxpro ?
>
>Any suggestions of coding would be really appreciated .
>
>Thanks in advance,
>Paul

lcWord1 = "VISUAL"
lcWord2 = "FOXPRO"
SELECT * FROM mytable ;
  WHERE lcWord1 $ UPPER( memofield1) ;
    OR lcWord2 $ UPPER( memofield1) ;
  INTO CURSOR crsResult

If you want case sensitive search than remove UPPER() function and specify lcWordN in the proper case. This query could be quite slow on big tables.