Re: Mask Account Number in Query

Malcolm Dew-Jones wrote:
> brett.birschbach_at_cellcom.com wrote:
> : In response to DA Morgan, That works fine if I know the length of the
> : account number. However, it doesnt work with varying lengths. The
> : replacement would be hardcoded to a certain number of asterisks, so in
> : my previous example, the accounts would show as
>
> : 123456 -> ******3456
> : 1234567890 -> ******7890
>
> Oracle SQL has lots of string manipulation functions. (Heck I think that
> even generic SQL has these functions.)
>
> One basic idea is to use one of those functions to find the length of the
> string, and then subtract four from that length, and then replace that
> many characters at the start of the string with the * character.

Exactly. A little INSTR ... a little LPAD ... and you're in business in a matter of a few minutes.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)