Re: Mask Account Number in Query

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 08 Sep 2005 17:44:51 +0200
Message-ID: <dfplr8$4v1$1_at_news2.zwoll1.ov.home.nl>


brett.birschbach_at_cellcom.com wrote:
> Oracle Version 9 is the DB
>
> Perl is the front end. I suppose I can do the masking in the front
> end, but I was hoping there was a way to do it in sql
>
Well, you could use a substr with length=4, and glue the last four digits to '*****', but that would be too easy, wouldn't it?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Sep 08 2005 - 17:44:51 CEST

Original text of this message