Are there a fixed set of delimiters in use in your "title" field?
If so then you could look for:
(Title = 'CAP'
OR Title like 'CAP %'
OR Title like '% CAP %'
OR Title like '% CAP')
-----Original Message-----
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 1:43 PM
To: CF-Talk
Subject: SOT: MSSQL Query help - Finding an exact word in a field
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:305835
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
