Re: Mask Account Number in Query

brett.birschbach_at_cellcom.com wrote:
> 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.

www.psoug.org
click on Morgan's Library
click on VIEWs
look at the "Create Single Table View For Security" demo

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