Questions on SQL Server 2008 Full-Text Search

Programmer Question

I have some questions about SQL 2K8 integrated full-text search.

Say I have the following tables:

1. Car with columns: id (int - pk), makeid (fk), description (nvarchar), year (int), features (int - bitwise value - 32 features only)


2. CarMake with columns: id (int - pk), mfgname (nvarchar)


3. CarFeatures with columns: id (int - 1, 2, 4, 8, etc.), featurename (nvarchar)

If someone searches "red honda civic 2002 4 doors", how would I parse the input string so that I could also search in the "CarMake" and "CarFeatures" tables?

Find the answer here