Finding similar data in two fields

[Dimitris]

Hello,
In a table T1 there are two fields F1 and F2. There are many records that
have common entries in those two fields. How can I find which entries have
common data in fields F1 and F2?

Thank you
Dimitris

 

[Brendan Reynolds]

Hello,
In a table T1 there are two fields F1 and F2. There are many records that
have common entries in those two fields. How can I find which entries have
common data in fields F1 and F2?

Thank you
Dimitris

Well if the values in the two fields are identical then it is simply ....

SELECT * FROM T1 WHERE F1 = F2

However, your subject line says 'similar' which leads me to wonder if the
values are in fact identical? If the values are similar but not actually
identical, then you may be able to do something with the LIKE operator, but
you'll probably have to explain your definition of 'similar' in this context
if you need more specific help than that.