Posted by Sharif Islam on 10/30/07 14:07

jhofmeyr@googlemail.com wrote:
> 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*"')

ah, that was it, thanks!

--sharif

• Next in forum: SqlClient connection to SQL 2005 creates 5000 tcp connections!
• Prev in forum: Re: some error in table definition
• Thread view: Re: CONTAINS and wildcard

[Reply to this message]