Posted by djamilabouzid on 10/03/06 00:35

Hi,

I have a question about MS SQL Server 2005:

I have a table in the database that contains 70 fields. I must perform
full-text search in about 60 fields. I use for that the full-text
searching "CONTAINS" like that:

SELECT ProductName
FROM Products
WHERE CONTAINS(ProductName, '"laugh*" NEAR lager')

My question is: for the 60 fields in the table that I want to do
full-text search for the same expression, may I write a query like
that:

Select f1, ..., fm
From table
Where CONTAINS(f1, expr) and CONTAINS(f2, exp) ... and
CONTAINS(f60,expr)

Or there is a more compact way to write this query.

Thank you very much for your answer,

Regard,

Djamila.

• Next in forum: Re: Best way to force a varchar column to have no whitespace
• Prev in forum: Re: Blank Password Policy problem
• Thread view: CONTAINS in SQL Server

[Reply to this message]