CONTAINS and wildcard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharif Islam - 29 Oct 2007 21:59 GMT

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

Reply to this Message

jhofmeyr@googlemail.com - 30 Oct 2007 00:51 GMT

> Is it a good idea to have multiple contains? I have this query:
>
[quoted text clipped - 7 lines]
>
> --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

Reply to this Message

Sharif Islam - 30 Oct 2007 15:07 GMT

>> Is it a good idea to have multiple contains? I have this query:
>>
[quoted text clipped - 18 lines]
> WHERE CONTAINS(Col1, '"Africa*"')
> OR CONTAINS(Col2, '"Africa*"')

ah, that was it, thanks!

--sharif

Reply to this Message