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.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Text Search Within a Sentence (Verity?)

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:

Select
date,
rep_id
FROM
table1 t1,
table2 t2(this is where the text is located)
where
date between 11/1/2012 and 12/1/2012
and t1.rep_id = t2.rep_id

and 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -