Thanks everyone. -----Original Message----- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:28 AM To: CF-Talk Subject: RE: sql query
The example below seems easier, but you could also: <cfset ssn_formatted = Left(ssn, 3)&"-"&Mid(ssn, 4, 2)&"-"&Right(ssn, 3)> v/r, Jeff -----Original Message----- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:20 AM To: CF-Talk Subject: Re: sql query 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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