You need to use Full Text Searching - you will need to install and configure it to use Boolean searches. BOL should give you what you need
-----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 03 June 2005 14:21 To: CF-Talk Subject: Boolean SQL searches in CF Hi, I am building an app for my employer and I need to implement a boolean search that will query an MS-SQL database. I was wondering how you guys handle this, are there functions out there that will help with this, or do I need to build my own parsing engine? I realize that Verity supports boolean searches, but I am only hitting the database and not using document indexing. Followup question, has anyone used Microsoft's English Query for SQL Server 2000 with CF, and would you have any tips? Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54