For anyone wanting to do something similar, this is a function using John's code as the basis.

Thanks for all of your replies

CREATE FUNCTION [dbo].[ScrubNumber] (@RawNumber varchar(100))

RETURNS varchar(100)

AS

BEGIN

...

Sean,

You are 100% correct. The data is encrypted. The issue is complicated, but we are adding an additional layer as a temp measure until the other party can get their...