> 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)# __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com ______________________________________________________________________ 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
