Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruchirj07
Starting Member
37 Posts |
 Posted - 2008-02-13 : 05:47:40
|
| Hi,I'm using "contains" keyword in the query. The column used in the contains is Full Text Indexed. The problem is when i have the data "10" and "10-Release" in the column and i use the queryselect * from table1 where contains(col1,'"10*"')it doesnot give me output but when i use the query select * from table1 where contains(col1,'"11*"')it returns me all the data having 11 in it like 11, 11-Release,111 etc etc.Can you please let me know what i'm missing.Ruchir |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-13 : 05:58:04
|
| Did you get any error? |
 |
|
|
ruchirj07
Starting Member
37 Posts |
Posted - 2008-02-13 : 05:59:22
|
| No error is returned but the data returned is not from the contains clause is incorrect. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-13 : 06:16:36
|
| Did you have a look at the noise words info? |
|
|
|
|
|
|
Problem in using "Contains"