Thanks for the great article. As soon as I read it. I started to implement full text search on our most used table.

I have altered the code to use CONTAINSTABLE(tblsite,*,@ftsQuery) because I want to be able to search in many fields.

But it is not working.

I have this field list with full text index on (Site (PK), SiteName, Address, HouseNumber, Zip, City)

I can search for "Vejle" (danish city) and I get result from columns SiteName and Address, so that works.

Now I want to search for "Vejle" and "17". I want to find the city "vejle" and all streets with housenumber "17" but the result set is empty. Can any one help me out on this? I think I have tried all search combination's