Chad, we got that to work with some tweaks. It was skipping stuff where CAP as the first word or last word. But yeah that did the trick.
Thanx to everyone that helped! You helped save the day. G$ On Wed, May 21, 2008 at 2:29 PM, Chad Gray <[EMAIL PROTECTED]> wrote: > I am full of incomplete thoughts. > > I _think_ you can abbreviate with a-z and 1-9 instead of typing out the > characters. > > > > > > -----Original Message----- > > From: Chad Gray [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 21, 2008 2:27 PM > > To: CF-Talk > > Subject: RE: MSSQL Query help - Finding an exact word in a field > > > > I re-read my post and I don't make any sense. I think I was typing > > faster than my brain was working. :) > > > > LIKE 'CAP[^T]%' > > > > Will not return records with CAPT at the beginning. > > > > So > > LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' > > > > Will return records with CAP or 8CAP9, but won't return records with > > CAPTAIN or CAPITAL. > > > > At least I think it will. Try it out. I am not in front of a MS SQL > > server. > > > > > > > > > > > -----Original Message----- > > > From: Chad Gray [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, May 21, 2008 2:17 PM > > > To: CF-Talk > > > Subject: RE: MSSQL Query help - Finding an exact word in a field > > > > > > I know you can use square brackets and the carrot symbol to exclude > > > characters. > > > > > > LIKE 'CAP[^T]%' > > > > > > Will give you everything that does not begin with CAPT > > > > > > So I _think_ you can do this. Try it and let me know. > > > LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' > > > > > > You are probably going to have to look at the records as you are > > > outputting them and toss out the bad ones so they don't display. > > > > > > Are you sure you cant turn FTS on? It is sooo much faster than LIKE. > > > > > > > > > > -----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:305841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
