Re: Mask Account Number in Query
From: T <t_at_yahoo.com>
Date: Mon, 12 Sep 2005 12:43:01 +0200
Message-ID: <dg3m71$e3r$1_at_ss405.t-com.hr>
Date: Mon, 12 Sep 2005 12:43:01 +0200
Message-ID: <dg3m71$e3r$1_at_ss405.t-com.hr>
First your problem was:
123456 -> **3456
1234567890 -> ******7890
then later,
123456 -> ******3456
1234567890 -> ******7890
take a choise or first describe your problem with more detail!!!
<brett.birschbach_at_cellcom.com> wrote in message
news:1126190803.692946.231980_at_g49g2000cwa.googlegroups.com...
> 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 Mon Sep 12 2005 - 12:43:01 CEST