You could do it in SQL, just like you said: DECLARE @oldSsn char(9) SET @oldSsn = '#ssn#'
DECLARE @newSsn char(11) SET @newSsn = SUBSTRING(@oldSsn, 1, 3) + '-' + SUBSTRING(@oldSsn, 4, 5) + '-' + SUBSTRING(@oldSsn, 6, 9) INSERT INTO myTable (ssn) VALUES (@newSsn) --- Billy Cravens -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:57 AM To: CF-Talk Subject: Re: sql query 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 > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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