Fix for Leading Zero in Social Security Number

Like zip codes, social security numbers have leading zeros. When importing them, sometimes the CSV file knocks off the leading zeros. There is a fix for leading zeros for zip codes using a Query with the operator of "Like" (https://kb.blackbaud.com/articles/Article/43975). There is no "Like" operator for SSNs. Here in Massachusetts, we have *a lot* of SSNs with the leading zero. Please create the ability to fix leading zeros in social security numbers like zip codes. Thanks.

  • Liz Rich
  • Sep 30 2016
  • Attach files