2 Replies Latest reply: May 15, 2014 10:01 AM by Grant Perkins RSS

    Format_SSN(,)  String Function Question

      Looks like a great tool for manipulating SSN.  I cannot find any information on the parameters, in particular add_hyphen and remove_hyphen formats.  How do these formats look like/work?

       

      Also, how can I preserve the leading zero (0) in a SSN.. or example:  038-xx-xxxx  when I strip out the hyphens (via strip(ssn,"-"), the result is 38-xx-xxxx.

       

      hgs