It's one that degrades as the week goes by, I think... And it IS Friday!
> -----Original Message----- > From: Don Vawter [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 12, 2002 2:02 PM > To: CF-Talk > Subject: Re: Quicky > > > Hmmh anal and "bare" (as in naked) mind. What kind of list is > this anyway? > ;) > > > > > ----- Original Message ----- > From: "Raymond Camden" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 12, 2002 1:30 PM > Subject: RE: Quicky > > > > The other poster had it right, but just to be anal, bare in mind yo dont > > need either the quotes or pounds below. Simply use: > > > > right(field1,12) > > > > not > > > > "#right(field1,12)#" > > > > Yes, I'm being anal. ;) > > > > ======================================================================= > > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > > > Email : [EMAIL PROTECTED] > > Yahoo IM : morpheus > > > > "My ally is the Force, and a powerful ally it is." - Yoda > > > > > -----Original Message----- > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, April 12, 2002 3:27 PM > > > To: CF-Talk > > > Subject: Re: Quicky > > > > > > > > > <cfset variable = "#Right(field1, 12)#"> > > > > > > That will get the rightmost characters (9 of them) from your field. > > > > > > Paul Giesenhagen > > > QuillDesign > > > http://www.quilldesign.com > > > SiteDirector v2.0 - Commerce Builder > > > > > > > > > > > > > I know the answer is easy, but it's late on Friday and it's > > > been a long > > > > week... > > > > Ok I need to set a variable with CFSET- (not in a query) to > > > be the last 12 > > > > characters of another field. > > > > ie: > > > > I want > > > > FIELD1: 12345678901234567890 > > > > to be set as: > > > > FIELD2: 901234567890 > > > > Thanks in advance. > > > > j > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists