Yeah, but you may be looking for love in all the wrong places. :O) Jim Blunt
-----Original Message----- From: Felicity Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:25 AM To: Exchange Discussions Subject: RE: Data Retreival from Exchange Database If you are using Exchange 2000 you should Full Text Index your database and then you could search on the subject matter you are looking for. For instance select ""DAV:DisplayName"" from scope(""DEEP TRAVERSAL"") where ""DAV:Subject"" contains('love') if you are looking for love :) You can also use this to search for the value of a property. I am not sure what properties are indexed by default with Full Text search, but have a look at the schema.txt file and it might be there. Perhaps someone else has some ideas on how to query and index other values than the defaults. --Felicity _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED]
