You could use Chr(65) though to Chr(90), this will give you A through to Z.
Chr() and Asc() together might give you something better. Ade -----Original Message----- From: SStewart [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 19:34 To: CF-Talk Subject: Anyone know of a more elegant way to do this? I'm incrementing a project number, it's an alpha-numeric "number" (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas <cfif Right(qry_getLastPnum.lPnum,2) CONTAINS "A"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"B"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "B"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"C"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "c"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"D"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "D"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"E"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "E"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"F"> Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 17/05/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207066 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
