We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR (tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%')
The problem is that "OR (tblProj.Title LIKE '%CAP%')" pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G "We learn something every day, and lots of times it's that what we learned the day before was wrong." - Bill Vaughan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
