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 |
|
vcs1161
Starting Member
10 Posts |
 Posted - 2013-02-20 : 12:41:50
|
| I am pretty sure there is a way to run a text search for words that are in the same sentence but can't seem to get the syntax right. I am working with Rapid SQL and trying to use a verity function "<many><sentence>(third, ventricle, pilocytic, astrocytoma)".I need to find results where all these words are in the same sentence within a large text area. So an example of what I am working with is:Selectdate,rep_idFROM table1 t1,table2 t2(this is where the text is located)wheredate between 11/1/2012 and 12/1/2012and t1.rep_id = t2.rep_idand this is where I stumble on looking for the keywords in t2 where third, ventricle, pilocytic, astrocytoma are in the text AND in the same sentence. Any advice is greatly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-20 : 13:11:20
|
| This is MS SQL Server forum and i dont think there are not enough people with expertise with Rapid SQL. You may be better off posting this in some relevant forums like www.dbforums.com------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Text Search Within a Sentence (Verity?)