Home Forums SQL Server 2005 T-SQL (SS2K5) T-SQL CONTAINS RE: T-SQL CONTAINS

  • June 19, 2008 at 8:19 am

    #831134

    I don't see why the data is split between the two tables. It would be easier if they were both in the same table. You would have only one full-text catalog and you can specify the two columns in the same CONTAINS query.

    That said, continue to use the CONTAINS function. Just use a double WHERE clause. For example,

    [font="Courier New"]SELECT

    desired columns

    FROM

    desired table(s)

    WHERE CONTAINS( query here )

    AND CONTAINS( query here )[/font]

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]