I have a table with a notes field and another table with text values that I need to search the notes field and find matches. Not sure if I am going in the right direction, below is not returning anything. If it were working I would like also to return the match value from the patterns table. Any Ideas to look at?

Details

SELECT [Router_ Notes_Q].item, [Router_ Notes_Q].oper_num, [Router_ Notes_Q].WorkCenter, [Router_ Notes_Q].Notes
FROM [Router_ Notes_Q]
WHERE (((Exists (SELECT  [Patterns].[PatternNum] FROM  [Patterns]
                                        WHERE [Router_ Notes_Q].[Notes]
                                       LIKE """*"" & [Patterns].[PatternNum]  & ""*"""))<>False));

Copy