|
|
Posted by Sharif Islam on 10/29/07 20:59
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
Navigation:
[Reply to this message]
|