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

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...