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:305840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
