SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

vcs1161
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:

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

India
52317 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
http://visakhm.blogspot.com/

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.06 seconds. Powered By: Snitz Forums 2000