Questions on SQL Server 2008 Full-Text Search

Posted by Eddie on Stack Overflow See other posts from Stack Overflow or by Eddie
Published on 2010-03-22T01:33:17Z Indexed on 2010/03/22 1:41 UTC
Read the original article Hit count: 350

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?

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about full-text-search