<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 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
