A field (string) is into other field (string)

[Victor2020]

Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.

 

[Jörn Bosse]

Am 05.06.2010 00:03, schrieb Victor2020:

Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.

You can use the StrComp-Function
http://office.microsoft.com/en-us/access/HA012289141033.aspx

or the InStr-Function
http://office.microsoft.com/en-us/access/HA012288571033.aspx

in a query.

Regards
Jörn

 

[Marshall Barton]

Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.

SELECT tbl1.*, tbl2.*
FROM tbl1, tbl2
WHERE tbl1.field Like "*" & tbl2.field & "*"
Or tbl2.field Like "*" & tbl1.field & "*"