[dba-SQLServer] Search your database....

Well a bit more googling turned up what I need, tho I'm still reading
the article, I hope this is all that is needed, anybody have any
special tricks, or caveats?...
http://www.databasejournal.com/features/mssql/article.php/3441981


On 5/31/05, Francisco Tapia <fhtapia at gmail.com> wrote:
> Yeah I forgot to mention, sorta like in the guise of Google/yahoo/msn etc..
> 
> 
> SEARCH [ Machine +RPM -small ]
> 
> would yeild all text w/ the word Machine and RPM but also exlcude the
> text w/ the word "small"
> 
> On 5/31/05, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> > Regular Expressions?
> >
> > Charlotte Foust
> >
> >
> > -----Original Message-----
> > From: Francisco Tapia [mailto:fhtapia at gmail.com]
> > Sent: Tuesday, May 31, 2005 3:54 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: [dba-SQLServer] Search your database....
> >
> >
> > Our company has been moving a lot of web content into SQL Server
> > databases... the purpose was to make them searchable.  I'm not exactly
> > sure how to go about searching the ntext fields for this information..
> > I'm thinking like, but is there a better method than the "like"
> > operator?
> >
> > maybe IN or EXISTS?
> 
> 
> 
> --
> -Francisco
> http://pcthis.blogspot.com |PC news with out the jargon!
> http://sqlthis.blogspot.com | Tsql and More...
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...