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 |
|
thakks
Starting Member
1 Post |
 Posted - 2014-10-01 : 10:45:18
|
| Hello friends,I am looking to filter the query using the free text predicate Contains for one of the column that have dimensions of the items. The query is something like Select * from sampletable where contains(filtercolumn, 'Near("*cm , *cm , *cm , *Kg.",10,True)')Data in the filtercolumn is something like 64cm x 25cm x 35cm = 10Kg.The query do not return any data. Please advise.I also tried running the below query to see if cm* can be searcher for, but with no result againSelect * from sampletable where contains(filtercolumn,, '"cm*"')If I do something like below, it does return all columns that have 35cm within the text.Select * from sampletable where contains(filtercolumn,, '"35cm"') |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
full text query using CONTAINS