Elam, Debbie
DElam at jenkens.com
Mon Jun 6 09:30:13 CDT 2005
If you are looking to search text fields, you may want to consider full text indexing. Once that is implemented on the database (this is not installed standard, and requires a job to update the index regularly) the syntax is: [YourIDfield] In (Select [YourIDfield] From [YourTable] Where Contains ([YourTextField],'words separated by AND')) Debbie -----Original Message----- From: Francisco Tapia [mailto:fhtapia at gmail.com] Sent: Tuesday, May 31, 2005 5: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 - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.