Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2008

Tip: Looking for answers? Try searching our database.

Multiple conditions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carlo - 25 Jul 2008 10:11 GMT
Hello

I'm not very familiar with fulltext search sintax, so I need your help..
In the contains statement I'd like to make a search like:
'FORMSOF (THESAURUS, "*long*") near FORMSOF (THESAURUS, "string*")'

but I get syntax error, any help?
Hilary Cotter - 30 Jul 2008 11:40 GMT
You can't combine operators like this and the wildcard is not
supported within the thesaurus option. The FreeText will do the
nearness/proximity and the thesaurus expansion, but it will not do the
wildcarding.

One thing you could do is expand long for each wildcard term you want
to find. IE have belongs an expansion of long, etc.

> Hello
>
[quoted text clipped - 3 lines]
>
> but I get syntax error, any help?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.