CONTAINS and wildcard
- From: Sharif Islam <mislam@xxxxxxxxxxxxxxx>
- Date: Mon, 29 Oct 2007 15:59:49 -0500
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
.
- Follow-Ups:
- Re: CONTAINS and wildcard
- From: jhofmeyr
- Re: CONTAINS and wildcard
- Prev by Date: Re: Error message with stored procedure
- Next by Date: Re: Two Tables with Left Outer Join & Where Clause
- Previous by thread: Error message with stored procedure
- Next by thread: Re: CONTAINS and wildcard
- Index(es):