this has nothing to do with sql. you have to parse the 9 digit number and set it equal to your reformatted number. Use left() or substring
On Wed, 1 May 2002, Joshua Tipton wrote: > 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
