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
