"geek-y-guy" <noone@nowhere.org> wrote in message
news:%23o7kKq5yGHA.4648@TK2MSFTNGP04.phx.gbl...
> Hi: Quick question...I have a FT catalog populated with a table of
> products. The catalog contains the product_id, product_name, and
> product_description fields.
>
> When I write a query, like:
>
> select p.*, k.rank from products p inner join
>
> containstable(products,product_name,'isabout (firestone weight(.9),tire
> weight (.1))') as k
>
> on p.p_id = k.[key]
>
> order by k.rank desc
>
>
> does the search only occur on the "product_name" field, or does it search
> all 3 fields in the catalog?
>

"geek-y-guy" <noone@nowhere.org> wrote in message
news:%23o7kKq5yGHA.4648@TK2MSFTNGP04.phx.gbl...
> Hi: Quick question...I have a FT catalog populated with a table of
> products. The catalog contains the product_id, product_name, and
> product_description fields.
>
> When I write a query, like:
>
> select p.*, k.rank from products p inner join
>
> containstable(products,product_name,'isabout (firestone weight(.9),tire
> weight (.1))') as k
>
> on p.p_id = k.[key]
>
> order by k.rank desc
>
>
> does the search only occur on the "product_name" field, or does it search
> all 3 fields in the catalog?
>