Mask Account Number in Query

From: <brett.birschbach_at_cellcom.com>
Date: 8 Sep 2005 07:46:43 -0700
Message-ID: <1126190803.692946.231980_at_g49g2000cwa.googlegroups.com>

[Quoted] [Quoted] Is there a (good) way to convert a column with account numbers to be masked all but the last 4 digits in such a way that:

123456 -> **3456
and
1234567890 -> ******7890

Thanks. Received on Thu Sep 08 2005 - 16:46:43 CEST