我是想用CONTAINS 谓词实现多个词搜索 中间用空格分开 可是有错误 望各位大虾帮我修改一下

[piaomiaoke]

select * from (SELECT InfoID AS id, CASE tradetype WHEN 0 THEN '供应' WHEN 1 THEN '求购' WHEN 2 THEN '合作' WHEN 3 THEN '代理' END AS searchsign,EnterpriseName + ' ' + CASE tradetype WHEN 0 THEN '供应' WHEN 1 THEN '求购' WHEN 2 THEN '合作' WHEN 3 THEN '代理' END + ' ' + ProductName AS title,ISNULL(ProductName, '')+ '|' + ISNULL(KeyWord1, '') + '|' + ISNULL(KeyWord2, '') + '|' + ISNULL(KeyWord3, '') + '|' + ISNULL(EnterpriseName,'') AS search, Date AS date FROM dbo.vb2b_InforTemp UNION ALL SELECT ID AS id, '资讯' AS searchsign, Title AS title, Title AS search, Date AS date FROM b2b_news) as infoandnews where 1=1 and CONTAINS(ProductName,'" + nameas[0] + "')
这个语句有 问题 谁帮我改一下 出的问题是“无法对search使用CONTAINS谓词 因为没有它没有编制全文索引”