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

So are you saying you *can't* use regular expressions??

Charlotte Foust


-----Original Message-----
From: Francisco Tapia [mailto:fhtapia at gmail.com] 
Sent: Tuesday, May 31, 2005 3:58 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com