I have a FTcatalog on a table called "products" where I'm indexing
"product_id", "product_name", "product_description"

I'm parsing a search box in a form and splitting on the spaces to
dynamically create the query, so someone my type in "Bob&Roy Video"

If I search for 'Bob&Roy' using containstable I get an error unless I wrap
it in double-quotes...is this the correct way to write the query?

select p.product_name, p.product_desc, k.rank from products p inner join

containstable(products,*,'isabout ("Mike&Ike" weight(.9),"video" weight
(.1))') as k

on p.product_id = k.[key]

order by k.rank desc

I'm not getting the results weighted the way I'd expect, but I'll tackle
that next.