Thanks all- I knew it was super easy- I had stuck in rtrim instead of right- my bleary eyes didn't catch it-
-----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 3:30 PM To: CF-Talk 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 > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
