ok i can do this <cfoutput> <cfset firstnumber = listfirst(#FORM.Proj_Num#,".")> <cfset lastnumber = IncrementValue(listlast(#FORM.Proj_Num#,"."))> <cfset MyNum = "#firstnumber#.#lastnumber#"> <CFSET Proj_Num2 = #MyNum#> </cfoutput>
But how do i make it insert 01 instead of 1? -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
