All you need is the Insert() function, something like: SSN = Insert("-", SSN, 3); SSN = Insert("-", SSN, 6);
>>> "Joshua Tipton" <[EMAIL PROTECTED]> 05/01/02 09:14AM >>> I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-9999. Can anyone help me with this? Joshua Tipton ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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