SQL Server Forums
Profile | Register | 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?)
 New Topic  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
like www.dbforums.com

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000