>> Any clue on how I can display a social security... Im having problems
>> if the first digit is a zero.... How do I format the number so it
>> displays all of the digits???
> First of all, you should use a string datatype in your database (VARCHAR,
> for instance).
> Second, assuming you're storing the SSN in the format '012345678' this
> will format it in the way most people are used to:
> #Left(SSN,3)#-#Mid(SSN,4,2)#-#Right(SSN,4)#
Or if you were feeling really adventurous,
#REReplace(SSN,"(.{3,3})(.{2,2})(.{4,4})","\1-\2-\3")#
or something to that effect. :)
Isaac Dealey
Certified Advanced ColdFusion Developer
www.turnkey.to
954-776-0046
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
