Posted by jhofmeyr on 10/29/07 23:51

On Oct 29, 8:59 pm, Sharif Islam <mis...@npspam.uiuc.edu> wrote:
> Is it a good idea to have multiple contains? I have this query:
>
> Select * from myTable where contains (Col1, 'Africa') or (Col2, 'Africa')
>
> Also, I tried this, didn't return anything:
>
> Select * from myTable where contains (Col1, 'Africa*') or (Col2, 'Africa')
>
> Both Col1 and Col2 has the string 'Africa' and 'African' in it.
>
> --sharif

Hi Sharif,

What version of SQL Server are you using? What is the error message
you are getting? Is the table configured for Full-Text Indexing?

Also - your syntax for the CONTAINS statement is incorrect. Try:
SELECT *
FROM myTable
WHERE CONTAINS(Col1, '"Africa*"')
OR CONTAINS(Col2, '"Africa*"')

Good luck!
J

• Next in forum: Re: Two Tables with Left Outer Join & Where Clause
• Prev in forum: Open SQL 2005 database question
• Thread view: Re: CONTAINS and wildcard

[Reply to this message]