I have a table with around 10,000 records. The records are medical claims, where an individual claimant may have many rows of different types of claims. The individuals are identified by their Social Security Number (ClaimantID). I've created a column, Claimant Alias, where I use the =RIGHT()...