I want to select records by comparing two similar text field in ArcGIS Desktop 10.3 (data stored in an ORACLE ArcSDE database).
I'm looking to select all records where field1 contain a string that is a part of the string in field2 (both fiels on the same table).
(field1 is the name and field2 the location, usually I have a name like "School" and a location like "Example street" but sometime the name is "House on this street" and the location is "this street", my goal is to filter these)
I know how to compare a field with part of a string :
field1 LIKE '%string%'
But I can't get it to work with two field, I tried lots of variation of
field1 LIKE '%field2%'
field1 LIKE '%' & field2 & '%'
But it never work, I get error messages like invalid character or missing closing parenthesis.
So is it possible to compare two field with the LIKE operator and how ?