searching for address matches using sql server 2008 full text search
- by Sridhar
Hi,
I am not sure how to search for address matches using sql server 2008 full text search. This is what I tried but it doesn't return any records.
TableA
------
Address1
Address2
City
State
Zip
All the above columns in the table are full text indexed. Let's say if the user enters
"123 Apple street FL 33647" and I have a record in the table as
…