I know I asked a question along these lines already, but as other issues became more important I let it go to the back of my mind. Well it's back!
I am currently working with an exported set of data, one of the fields contains social security numbers. Currently when I input the data it puts in the whole SSN. I was wondering if there was a way to replace the first 5 numbers with X and leave the last 4 numbers alone. ie: 123-45-6789 would become XXX-XX-6789. This is purely for security reasons. I thought about using the mask function, but if I recall that would just be used to validate that the SSN was formatted right. I also thought about using the replace function, but I have no clue where I would start there. Thanks again for the help, hopefully i'll be able to answer questions soon instead of asking them. ~Steve ____________________________________________________________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
