CONTAINS and wildcard

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

Re: CONTAINS and wildcard

On Oct 29, 8:59 pm, Sharif Islam 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

Re: CONTAINS and wildcard

jhofmeyr@googlemail.com wrote:
> On Oct 29, 8:59 pm, Sharif Islam 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