Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Text Search Within a Sentence (Verity?)
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

10 Posts

Posted - 02/20/2013 :  12:41:50  Show Profile  Reply with Quote
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:

table1 t1,
table2 t2(this is where the text is located)
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.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 02/20/2013 :  13:11:20  Show Profile  Reply with Quote
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

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000