Thank you, SSC Rookie. We decided to add new column on publisher table, add trigger to populate the new column with last 4 digits and replicate the new column.

Appreciate...

Got your point. Thant will duplicate the table. I guess it is better to have extra column on same table and populate with RIGHT(SSN, 4).

One more quick question, can...

Thank you for the pointers.

Creating a computed column on publication or subscriber to fetch just 4 digits will be my last option.

I would like to try your first option:...

Thank you for the quick reply. Requirement is: We want to replicate data from Production to test environments and want to publish selected columns and part of SSN to test...