FullText search with fields, not values?

[jsteph]

Hi all,
I have a table that contains a field Address and a field City. Sometimes the Address already contains the City field, ie, City is redundant.

I want to find these records.

I tried:
Select Address ,City
FROM tblAddr
where contains([Address],[City])

This gives a syntax error, however

Select Address ,City
FROM tblAddr
where contains([Address],'Chicago')

...this works fine so the FT capability is not at issue.
Is it impossible to do an FT search using another field as the search term?
Thanks,
--Jim

 

[markros]

If the table in not huge, you can split values in the Address column using any of the splitting functions available and then you would be able to check such records.

PluralSight Learning Library

 

[jsteph]

I just want to know if the Contains() or Freetext() will allow one to use a table field for both arguments--the string to be searched and the string to look for.
--Jim

 

[markros]

AFAIK, no.

PluralSight Learning Library