... records from another table that has "1019x1y3" if found in the memo field: Select myfield,csrindex from myTable where ( csrindex IN ( Select myMemo from TMem ) ) into cursor foundit The SQL IN operator does not check, whether the left operand (csrindex) is a substring of some of the found values of the right subselect. It only checks, whether at least one of the ...

... those records from another table that has "1019x1y3" if found in the memo field: Select myfield,csrindex from myTable where ( csrindex IN ( Select myMemo from TMem ) ) into cursor foundit I haven't worked much with memofields. Suggestions? TIA Steve Make a copy of the 'myTable'. Then: Start by entering 'Memo' in the command line, and hitting F1. ...

... Tmem has one record that has a memo field has 1019x1y2 1019x1y3 1019x1y4 csrindex="1019x1y3" I'm trying to select those records from another table that has "1019x1y3" if found in the memo field: Select myfield,csrindex from myTable where ( csrindex IN ( Select myMemo from TMem ) ) into cursor foundit I haven't worked much with memofields. Suggestions? TIA Steve