Question on Like * values

[SKV]

I want to filter records based on specific words which can places any where with that field record.

I am looking for a solution to have a table with list of these words and then use this table to flag records that contain these words in my original table.

Please guide on how to develop this solution.

I can do hard coding like *xx* but want to avoid it if possible.

Thanks
SKV

 

[smozgur]

You can use subquery with EXISTS:

In the SQL query below, tbl_main is the main table with fld_lookin field that you are trying to match with the values in the tbl_lookup table's fld_keyword field.

SELECT *
FROM tbl_main
WHERE EXISTS (
  SELECT fld_keyword FROM tbl_lookup 
  WHERE tbl_main.fld_lookin LIKE "*" & fld_keyword  & "*"
);

I hope it helps.

I want to filter records based on specific words which can places any where with that field record.

I am looking for a solution to have a table with list of these words and then use this table to flag records that contain these words in my original table.

Please guide on how to develop this solution.

I can do hard coding like *xx* but want to avoid it if possible.

Thanks
SKV